ETL Project - The Best 50 Superhero Movies

ETL is a type of data integration that refers to the three steps (extract, transform, load) used to blend data from multiple sources. It's often used to build a data warehouse. During this process, data is taken (extracted) from a source system, converted (transformed) into a format that can be analyzed, and stored (loaded) into a data warehouse or other system. Extract, load, transform (ELT) is an alternate but related approach designed to push processing down to the database for improved performance.

Project Proposal

  • Combine the Best 50 Superhero Movies dataset with The Superhero dataset for the analysis and data visualization.

3 questions relating to the data:

For the 3 questions, I decided to focus exclusively on American superheroes and movies.

  1. Is there a gender bias in superhero movie industry?

  2. What are the most important variables in predicting movie's profitability.

  3. For production companies that were acquired, how much on average has each superhero earned?

Extract Data:

Data sources: • Superheroes API • Web Scraping • Movies API • Python package - IMDbPY

Data formats: • CSV • XLSX • pgAdmin • HTML

Transform Data:

• cleaning • joining • filtering • aggregating (group by, sort, average, count) • deleting columns • data visualization

Load Data:

       load the final database into the PostgreSQL database server.


Flask Application:

       render images for each movie, superhero and a short movie summary from the database.
In [8]:
# import dependencies 
import matplotlib.pyplot as plt
import pandas as pd
import numpy as np
import requests
import time
from scipy.stats import linregress
from pprint import pprint
import json

Data Preparation (general)

In [9]:
# PART 1 =====================================
# First sorce of data comes from superhero API.
# requests library helps us get the content from the API by using the get() method. 

url = "https://superhero-search.p.rapidapi.com/"

querystring = {"hero":"spiderman"}



response = requests.request("GET", url, headers=headers, params=querystring)

print(response.text)
{"id":476,"name":"Spider-Man","slug":"620-spider-man","powerstats":{"intelligence":90,"strength":55,"speed":67,"durability":75,"power":74,"combat":85},"appearance":{"gender":"Male","race":"Human","height":["5'10","178 cm"],"weight":["165 lb","74 kg"],"eyeColor":"Hazel","hairColor":"Brown"},"biography":{"fullName":"Peter Parker","alterEgos":"No alter egos found.","aliases":["Spiderman","Bag-Man","Black Marvel","Captain Universe","Dusk","Green Hood","Hornet","Mad Dog 336","Peter Palmer","Prodigy","Ricochet","Scarlet Spider","Spider-Boy","Spider-Hulk","Spider-Morphosis"],"placeOfBirth":"New York, New York","firstAppearance":"Amazing Fantasy #15","publisher":"Marvel Comics","alignment":"good"},"work":{"occupation":"Freelance photographer, teacher","base":"New York, New York"},"connections":{"groupAffiliation":"Member of the Avengers, formerly member of Outlaws, alternate Fantastic Four","relatives":"Richard Parker (father, deceased), Mary Parker(mother, deceased), Benjamin Parker (uncle, deceased), May Parker (aunt), Mary Jane Watson-Parker (wife), May Parker (daughter, allegedly deceased)"},"images":{"xs":"https://cdn.rawgit.com/akabab/superhero-api/0.2.0/api/images/xs/620-spider-man.jpg","sm":"https://cdn.rawgit.com/akabab/superhero-api/0.2.0/api/images/sm/620-spider-man.jpg","md":"https://cdn.rawgit.com/akabab/superhero-api/0.2.0/api/images/md/620-spider-man.jpg","lg":"https://cdn.rawgit.com/akabab/superhero-api/0.2.0/api/images/lg/620-spider-man.jpg"}}
In [10]:
# Python has a built-in package called json, which can be used to work with JSON data we get from the API.
response = requests.get(url, headers=headers, params=querystring).json()
print(json.dumps(response, indent=4, sort_keys=True))
{
    "appearance": {
        "eyeColor": "Hazel",
        "gender": "Male",
        "hairColor": "Brown",
        "height": [
            "5'10",
            "178 cm"
        ],
        "race": "Human",
        "weight": [
            "165 lb",
            "74 kg"
        ]
    },
    "biography": {
        "aliases": [
            "Spiderman",
            "Bag-Man",
            "Black Marvel",
            "Captain Universe",
            "Dusk",
            "Green Hood",
            "Hornet",
            "Mad Dog 336",
            "Peter Palmer",
            "Prodigy",
            "Ricochet",
            "Scarlet Spider",
            "Spider-Boy",
            "Spider-Hulk",
            "Spider-Morphosis"
        ],
        "alignment": "good",
        "alterEgos": "No alter egos found.",
        "firstAppearance": "Amazing Fantasy #15",
        "fullName": "Peter Parker",
        "placeOfBirth": "New York, New York",
        "publisher": "Marvel Comics"
    },
    "connections": {
        "groupAffiliation": "Member of the Avengers, formerly member of Outlaws, alternate Fantastic Four",
        "relatives": "Richard Parker (father, deceased), Mary Parker(mother, deceased), Benjamin Parker (uncle, deceased), May Parker (aunt), Mary Jane Watson-Parker (wife), May Parker (daughter, allegedly deceased)"
    },
    "id": 476,
    "images": {
        "lg": "https://cdn.rawgit.com/akabab/superhero-api/0.2.0/api/images/lg/620-spider-man.jpg",
        "md": "https://cdn.rawgit.com/akabab/superhero-api/0.2.0/api/images/md/620-spider-man.jpg",
        "sm": "https://cdn.rawgit.com/akabab/superhero-api/0.2.0/api/images/sm/620-spider-man.jpg",
        "xs": "https://cdn.rawgit.com/akabab/superhero-api/0.2.0/api/images/xs/620-spider-man.jpg"
    },
    "name": "Spider-Man",
    "powerstats": {
        "combat": 85,
        "durability": 75,
        "intelligence": 90,
        "power": 74,
        "speed": 67,
        "strength": 55
    },
    "slug": "620-spider-man",
    "work": {
        "base": "New York, New York",
        "occupation": "Freelance photographer, teacher"
    }
}
In [11]:
# set up lists to hold reponse info
hero_id = []
name = []
fullName = []
gender = []
eyeColor = []
hairColor = []
height = []
weight = []
race = []
placeOfBirth = []
work = []
images = []
publisher = []
intelligence = []
power = []
firstAppearance = []
count = 0
count_error = 0



# Loop through the list of 561 heroes and perform a request for each hero
for i in range(561):
    
        url = "https://superhero-search.p.rapidapi.com/"

        querystring = {"id": i}

        headers = {
                    'x-rapidapi-host': "superhero-search.p.rapidapi.com",
                    'x-rapidapi-key': "5a8ea71761msh2e12845540e03c1p1bacdfjsn766f6824866c"
                    }

        response = requests.get(url, headers=headers, params=querystring).json()
#         print(json.dumps(response, indent=4, sort_keys=True))
        try:
    #         pprint(response)
#             print('==============')



            id_v = (response['id'])
            name_v = (response['name'])
            fullName_v = (response['biography']['fullName'])
            gender_v = response['appearance']['gender']
            eyeColor_v = response['appearance']['eyeColor']
            hairColor_v =  response['appearance']['hairColor']
            height_v = response['appearance']['height'][0]
            weight_v = response['appearance']['weight'][0]
            race_v = response['appearance']['race']
            placeOfBirth_v = (response['biography']['placeOfBirth'])
            work_v = response['work']['occupation']
            images_v =  response['images']['lg']
            publisher_v = (response['biography']['publisher'])
            firstAppearance_v = response['biography']['firstAppearance'] 
            intelligence_v = response['powerstats']['intelligence']
            power_v = response['powerstats']['power']
            

            hero_id.append(id_v)
            name.append(name_v)
            fullName.append(fullName_v)
            gender.append(gender_v)
            eyeColor.append(eyeColor_v)
            hairColor.append(fullName_v)
            height.append(height_v)
            weight.append(weight_v)
            race.append(race_v)
            placeOfBirth.append(placeOfBirth_v)
            work.append(work_v)
            images.append(images_v)
            publisher.append(publisher_v)
            intelligence.append(intelligence_v)
            power.append(power_v)
            firstAppearance.append(firstAppearance_v)
#             print(count)
            count +=1


        except (KeyError, IndexError):
            count_error +=1
            print(f"Missing field/result... skipping. {count_error}") 

print(f"Total results :{count} heros")        
print(f"Missing field/result:{count_error} errors") 
        
Total results :561 heros
Missing field/result:0 errors
In [12]:
# creating a data frame for heroes
hero_dict = {
        "hero_id" : hero_id,
        "name" : name,
        "fullName":fullName,
        "gender":gender,
        "eyeColor" :eyeColor,
        "hairColor":hairColor,
        "height":height,
        "weight":weight,
        "race" :race,
        "placeOfBirth":placeOfBirth,
        "work" : work,
        "images": images,
        "publisher": publisher,
        "intelligence":intelligence,
        "power":power,
        "firstAppearance":firstAppearance
}

hero_df = pd.DataFrame(hero_dict)
print(hero_df.count())
hero_df.head()
hero_id            561
name               561
fullName           561
gender             561
eyeColor           561
hairColor          561
height             561
weight             561
race               398
placeOfBirth       561
work               561
images             561
publisher          555
intelligence       561
power              561
firstAppearance    561
dtype: int64
Out[12]:
hero_id name fullName gender eyeColor hairColor height weight race placeOfBirth work images publisher intelligence power firstAppearance
0 0 A-Bomb Richard Milhouse Jones Male Yellow Richard Milhouse Jones 6'8 980 lb Human Scarsdale, Arizona Musician, adventurer, author; formerly talk sh... https://cdn.rawgit.com/akabab/superhero-api/0.... Marvel Comics 38 24 Hulk Vol 2 #2 (April, 2008) (as A-Bomb)
1 1 Abe Sapien Abraham Sapien Male Blue Abraham Sapien 6'3 145 lb Icthyo Sapien - Paranormal Investigator https://cdn.rawgit.com/akabab/superhero-api/0.... Dark Horse Comics 88 100 Hellboy: Seed of Destruction (1993)
2 2 Abin Sur Male Blue 6'1 200 lb Ungaran Ungara Green Lantern, former history professor https://cdn.rawgit.com/akabab/superhero-api/0.... DC Comics 50 99 Showcase #22 (October, 1959)
3 3 Abomination Emil Blonsky Male Green Emil Blonsky 6'8 980 lb Human / Radiation Zagreb, Yugoslavia Ex-Spy https://cdn.rawgit.com/akabab/superhero-api/0.... Marvel Comics 63 62 Tales to Astonish #90
4 4 Abraxas Abraxas Male Blue Abraxas - - lb Cosmic Entity Within Eternity Dimensional destroyer https://cdn.rawgit.com/akabab/superhero-api/0.... Marvel Comics 88 100 Fantastic Four Annual #2001

Data Preparation (Question 1)

In [13]:
# Data cleaning for hero_df. Deleting some columns, that do not have valuable info
hero_df = hero_df.drop(['hero_id', 'hairColor', 'firstAppearance', 'publisher'], axis=1)
hero_df.head()
Out[13]:
name fullName gender eyeColor height weight race placeOfBirth work images intelligence power
0 A-Bomb Richard Milhouse Jones Male Yellow 6'8 980 lb Human Scarsdale, Arizona Musician, adventurer, author; formerly talk sh... https://cdn.rawgit.com/akabab/superhero-api/0.... 38 24
1 Abe Sapien Abraham Sapien Male Blue 6'3 145 lb Icthyo Sapien - Paranormal Investigator https://cdn.rawgit.com/akabab/superhero-api/0.... 88 100
2 Abin Sur Male Blue 6'1 200 lb Ungaran Ungara Green Lantern, former history professor https://cdn.rawgit.com/akabab/superhero-api/0.... 50 99
3 Abomination Emil Blonsky Male Green 6'8 980 lb Human / Radiation Zagreb, Yugoslavia Ex-Spy https://cdn.rawgit.com/akabab/superhero-api/0.... 63 62
4 Abraxas Abraxas Male Blue - - lb Cosmic Entity Within Eternity Dimensional destroyer https://cdn.rawgit.com/akabab/superhero-api/0.... 88 100
In [14]:
# Saving the dataframe to heroes.csv file
hero_df.to_csv('heroes.csv', index=False) 
In [15]:
# Creating a test data frame from heroes.csv 
test_df = pd.read_csv('heroes.csv')

# Data Cleanup & Analysis
test_df.loc[test_df['gender'] == '-', 'gender'] = 'Other'
test_df.head()
Out[15]:
name fullName gender eyeColor height weight race placeOfBirth work images intelligence power
0 A-Bomb Richard Milhouse Jones Male Yellow 6'8 980 lb Human Scarsdale, Arizona Musician, adventurer, author; formerly talk sh... https://cdn.rawgit.com/akabab/superhero-api/0.... 38 24
1 Abe Sapien Abraham Sapien Male Blue 6'3 145 lb Icthyo Sapien - Paranormal Investigator https://cdn.rawgit.com/akabab/superhero-api/0.... 88 100
2 Abin Sur NaN Male Blue 6'1 200 lb Ungaran Ungara Green Lantern, former history professor https://cdn.rawgit.com/akabab/superhero-api/0.... 50 99
3 Abomination Emil Blonsky Male Green 6'8 980 lb Human / Radiation Zagreb, Yugoslavia Ex-Spy https://cdn.rawgit.com/akabab/superhero-api/0.... 63 62
4 Abraxas Abraxas Male Blue - - lb Cosmic Entity Within Eternity Dimensional destroyer https://cdn.rawgit.com/akabab/superhero-api/0.... 88 100
In [16]:
# Groupby gender and calculating avarage intelligence for each group
test_df.groupby('gender')['intelligence'].mean()
test_df.groupby('gender')['name'].count()
gender_df = pd.DataFrame()
gender_df['count'] = test_df.groupby('gender')['name'].count()
gender_df['avr intelligence'] = round(test_df.groupby('gender')['intelligence'].mean(), 2)
gender_df =gender_df.reset_index()
gender_df
Out[16]:
gender count avr intelligence
0 Female 151 62.50
1 Male 395 65.42
2 Other 15 60.40
In [17]:
import plotly.graph_objects as go
x = ['Female', 'Male', 'Other']


fig = go.Figure(data=[
    go.Bar(name='count', x=x, y = gender_df['count']),
    go.Bar(name='intelligence', x=x, y = gender_df['avr intelligence'])
])
# Change the bar mode
fig.update_layout(barmode='group')


fig.update_layout(
    font=dict(
        family="Courier New, monospace",
        size=18,
        color="#7f7f7f"
    ),
    title={
        'text':'SuperHeroes Counts and Intelligence by Gender',
        'y':0.9,
        'x':0.5,
        'xanchor': 'center',
        'yanchor': 'top'}
)

fig.update_xaxes(title_text='Gender')
fig.update_yaxes(title_text='Count / Intelligence')

fig.show()
In [18]:
import plotly.express as px
df = test_df

fig = px.scatter(df, x="power", y="weight", facet_col="gender")
fig.update_xaxes(title_font=dict(size=18, family='Courier', color='crimson'))
fig.update_yaxes(title_font=dict(size=18, family='Courier', color='red'))


fig.update_layout(
    font=dict(
        family="Courier New, monospace",
        size=18,
        color="#7f7f7f"
    ),
    title={
        'text':'SuperHeroes Power vs Weight by Gender',
        'y':1,
        'x':0.5,
        'xanchor': 'center',
        'yanchor': 'top'}
)

fig.show()

Data Analysis

  1. I found that there is gender inequality in the Superheroes dataset. There are 395 male heroes, 151 female heroes and 15 other gender heroes. The average intelligence for a male hero is 65.42 points. It is higher than the average intelligence for a female hero (62.50). Clearly, there are the immediate issues of parity, equal treatment and human rights.

  2. Looks like there is no strong correlation between the power of hero and his/her/other weight.

  3. There is no question that watching films can help us escape our everyday lives. However, all films impact our society and popular culture. I am sure that a growing number of female superheroes with a high intelligence will empower girls and women all around the world.

In [19]:
# PART 2 =====================================
# Second sorce of data comes from scraping a web page with a list of best 50 Superheroes movies af all time.

from bs4 import BeautifulSoup
import requests

url = 'http://superheroes.theringer.com/?_ga=2.205407573.49282893.1583382995-1394544322.1583382995'
In [20]:
# Retrieve page with the requests module
response = requests.get(url)
In [21]:
# Create BeautifulSoup object; 
# parse with 'html.parser'
soup = BeautifulSoup(response.text, 'html.parser')
In [22]:
# Examine the results
# print(soup.prettify())
In [23]:
# results are returned as an iterable list
results = soup.find_all('li', class_='card-item')

# results[0].text
# results[0]
In [24]:
# Creating lists to hold the info
rank = []
title= []
date= []
rottenTomatoes= []
boxOffice= []
rewatchability= []
totalScore= []
image= []

# Loop through returned results
for result in results:
#     print(result)
    # Error handling
    try:
        # Identify and return title of the movie
        title_v = result.find('span', class_="title").text
#         print(title_v)
        # Identify and return date of the movie
        date_v = result.find('span', class_="date").text
#         print(date_v)
        
        rank_v = result.find('div', class_="rank").span.text
#         print(rank_v)
        
        rottenTomatoes_v = result.find('span', class_="data").text
#         print(rottenTomatoes_v)
    
        boxOfficeB = result.find('div', class_='expanded-data-col adjusted')
        boxOffice_v = boxOfficeB.find('span', class_='data offset').text
#         print(boxOffice_v)
        
        rewatchabilityB = result.find('div', class_='expanded-data-col rewatchability')
        rewatchability_v = rewatchabilityB.find('span', class_='data').text
#         print(rewatchability_v)
        
        totalScoreB = result.find('div', class_='expanded-data-col score')
        totalScore_v = totalScoreB.find('span', class_='data').text
#         print(totalScore_v)
        
        # Identify and return an image link 
        image_v = result.find('div', class_="image")['data-src']
#         print(image_v)
        
        

        rank.append(rank_v)
        title.append(title_v)
        date.append(date_v)
        rottenTomatoes.append(rottenTomatoes_v)
        boxOffice.append(boxOffice_v)
        rewatchability.append(rewatchability_v)
        totalScore.append(totalScore_v)
        image.append(image_v)

        
        
        # Print results only if items are available
#         if (title and date and rank and rottenTomatoes and boxOffice and rewatchability and totalScore and image):
#             print('-------------')
#             print(rank)
#             print(title)
#             print(date)
#             print(rottenTomatoes)
#             print(boxOffice)
#             print(rewatchability)
#             print(totalScore)
#             print(image)
    except AttributeError as e:
        print(e)
In [25]:
# create a data frame for the best 50 movies
best_50_movies_dict = {
        "rank" : rank,
        "title" : title,
        "date":date,
        "rottenTomatoes":rottenTomatoes,
        "boxOffice" :boxOffice,
        "rewatchability":rewatchability,
        "totalScore":totalScore,
        "image":image
}

movies_df = pd.DataFrame(best_50_movies_dict)
movies_df.to_csv('movies.csv', index=False)
print(movies_df.count())
movies_df.head(50)
rank              50
title             50
date              50
rottenTomatoes    50
boxOffice         50
rewatchability    50
totalScore        50
image             50
dtype: int64
Out[25]:
rank title date rottenTomatoes boxOffice rewatchability totalScore image
0 50 The Crow 1994 82% $83.3M 6.25 125 https://hardrefreshcdn.com/public/media/superh...
1 49 Batman Forever 1995 41% $295M 5.82 130 https://hardrefreshcdn.com/public/media/superh...
2 48 Hellboy II: The Golden Army 2008 85% $87M 7.00 134 https://hardrefreshcdn.com/public/media/superh...
3 47 Thor: The Dark World 2013 66% $219M 4.45 134 https://hardrefreshcdn.com/public/media/superh...
4 46 Man of Steel 2013 55% $309M 3.91 139 https://hardrefreshcdn.com/public/media/superh...
5 45 Thor 2011 77% $199M 5.09 142 https://hardrefreshcdn.com/public/media/superh...
6 44 Shazam! 2019 91% $140.4M 4.00 143 https://hardrefreshcdn.com/public/media/superh...
7 43 X-Men: The Last Stand 2006 58% $286M 4.70 144 https://hardrefreshcdn.com/public/media/superh...
8 42 Ant-Man 2015 82% $183M 7.00 150 https://hardrefreshcdn.com/public/media/superh...
9 41 The Amazing Spider-Man 2012 72% $282M 4.36 151 https://hardrefreshcdn.com/public/media/superh...
10 40 Captain America: The First Avenger 2011 80% $194M 7.45 151 https://hardrefreshcdn.com/public/media/superh...
11 39 Superman Returns 2006 76% $286M 3.91 152 https://hardrefreshcdn.com/public/media/superh...
12 38 X-Men: First Class 2011 86% $161M 9.09 154 https://hardrefreshcdn.com/public/media/superh...
13 37 X-Men 2000 81% $223M 7.40 157 https://hardrefreshcdn.com/public/media/superh...
14 36 Ant-Man and the Wasp 2018 88% $217M 3.80 157 https://hardrefreshcdn.com/public/media/superh...
15 35 Aquaman 2018 64% $335M 6.50 159 https://hardrefreshcdn.com/public/media/superh...
16 34 Spider-Man 3 2007 63% $399M 4.09 159 https://hardrefreshcdn.com/public/media/superh...
17 33 Doctor Strange 2016 89% $233M 5.00 166 https://hardrefreshcdn.com/public/media/superh...
18 32 Batman Returns 1992 81% $283M 6.80 168 https://hardrefreshcdn.com/public/media/superh...
19 31 Batman Begins 2005 84% $256M 8.00 169 https://hardrefreshcdn.com/public/media/superh...
20 30 X-Men: Days of Future Past 2014 90% $244M 6.09 170 https://hardrefreshcdn.com/public/media/superh...
21 29 Spider-Man: Into the Spider-Verse 2018 97% $190M 10.0 170 https://hardrefreshcdn.com/public/media/superh...
22 28 Superman II 1981 87% $290M 4.33 170 https://hardrefreshcdn.com/public/media/superh...
23 27 X2: X-Men United 2003 86% $287M 5.60 171 https://hardrefreshcdn.com/public/media/superh...
24 26 Iron Man 2 2010 73% $353M 5.64 172 https://hardrefreshcdn.com/public/media/superh...
25 25 Deadpool 2 2018 83% $325M 5.20 172 https://hardrefreshcdn.com/public/media/superh...
26 24 Logan 2017 93% $226M 9.27 174 https://hardrefreshcdn.com/public/media/superh...
27 23 Captain Marvel 2019 78% $427M 2.50 176 https://hardrefreshcdn.com/public/media/superh...
28 22 Captain America: The Winter Soldier 2014 89% $271M 7.70 176 https://hardrefreshcdn.com/public/media/superh...
29 21 Avengers: Age of Ultron 2015 75% $467M 5.18 180 https://hardrefreshcdn.com/public/media/superh...
30 20 Thor: Ragnarok 2017 93% $315M 7.50 183 https://hardrefreshcdn.com/public/media/superh...
31 19 Guardians of the Galaxy Vol. 2 2017 82% $389M 6.82 186 https://hardrefreshcdn.com/public/media/superh...
32 18 Batman 1989 72% $493M 7.50 186 https://hardrefreshcdn.com/public/media/superh...
33 17 Deadpool 2016 84% $363M 7.36 187 https://hardrefreshcdn.com/public/media/superh...
34 16 Iron Man 3 2013 79% $434M 6.91 187 https://hardrefreshcdn.com/public/media/superh...
35 15 Spider-Man: Far From Home 2019 90% $373M 7.00 189 https://hardrefreshcdn.com/public/media/superh...
36 14 Spider-Man: Homecoming 2017 92% $333M 7.45 191 https://hardrefreshcdn.com/public/media/superh...
37 13 Guardians of the Galaxy 2014 91% $348M 7.55 192 https://hardrefreshcdn.com/public/media/superh...
38 12 The Dark Knight Rises 2012 87% $482M 6.91 193 https://hardrefreshcdn.com/public/media/superh...
39 11 Captain America: Civil War 2016 90% $408M 7.55 196 https://hardrefreshcdn.com/public/media/superh...
40 10 Iron Man 2008 94% $364M 7.82 197 https://hardrefreshcdn.com/public/media/superh...
41 9 Avengers: Infinity War 2018 84% $679M 8.0 198 https://hardrefreshcdn.com/public/media/superh...
42 8 Wonder Woman 2017 92% $412M 8.00 201 https://hardrefreshcdn.com/public/media/superh...
43 7 Spider-Man 2 2004 94% $483M 5.91 201 https://hardrefreshcdn.com/public/media/superh...
44 6 Spider-Man 2002 89% $550M 7.27 205 https://hardrefreshcdn.com/public/media/superh...
45 5 Superman 1978 93% $502M 5.67 206 https://hardrefreshcdn.com/public/media/superh...
46 4 The Avengers 2012 92% $671M 7.36 210 https://hardrefreshcdn.com/public/media/superh...
47 3 Avengers: Endgame 2019 94% $858M 7.50 212 https://hardrefreshcdn.com/public/media/superh...
48 2 Black Panther 2018 96% $700M 9.60 213 https://hardrefreshcdn.com/public/media/superh...
49 1 The Dark Knight 2008 94% $612M 9.27 214 https://hardrefreshcdn.com/public/media/superh...

Data Preparation (Question 2)

In [26]:
# Data Cleanup & Analysis
# Getting a value for the boxOffice column. Cutting '$' and 'M' : $83.3M  will make 83.3
movies_df['boxOffice'] = movies_df['boxOffice'].str[1:-1].astype(float)
movies_df.head()
Out[26]:
rank title date rottenTomatoes boxOffice rewatchability totalScore image
0 50 The Crow 1994 82% 83.3 6.25 125 https://hardrefreshcdn.com/public/media/superh...
1 49 Batman Forever 1995 41% 295.0 5.82 130 https://hardrefreshcdn.com/public/media/superh...
2 48 Hellboy II: The Golden Army 2008 85% 87.0 7.00 134 https://hardrefreshcdn.com/public/media/superh...
3 47 Thor: The Dark World 2013 66% 219.0 4.45 134 https://hardrefreshcdn.com/public/media/superh...
4 46 Man of Steel 2013 55% 309.0 3.91 139 https://hardrefreshcdn.com/public/media/superh...
In [27]:
# This chart contains the top movies based on the cumulative worldwide box office vs  rotten tomatoes ratings,  and total score
import plotly.express as px
from plotly.subplots import make_subplots
x =movies_df['title']

# Create traces
fig = go.Figure()

# Create figure with secondary y-axis
fig = make_subplots(specs=[[{"secondary_y": True}]])


fig.add_trace(go.Scatter(x=x, y=movies_df['boxOffice'] + 5,
                    mode='lines',
                    name='Box Office'),
                    secondary_y=False,)
fig.add_trace(go.Scatter(x=x, y=movies_df['rottenTomatoes'],
                    mode='lines+markers',
                    name='Rotten Tomatoes'),
                    secondary_y=True,)
fig.add_trace(go.Scatter(x=x, y=movies_df['totalScore'],
                    mode='lines+markers',
                    name='Total Score'),
                    secondary_y=True,)
# fig.add_trace(go.Scatter(x=x, y=movies_df['rewatchability'],
#                     mode='lines+markers',
#                     name='Rewatchability'),
#                     secondary_y=True,)


fig.update_layout(
    font=dict(
        family="Courier New, monospace",
        size=18,
        color="#7f7f7f"
    ),
    title={
        'text':'Box office vs Movie Rating',
        'y':1,
        'x':0.4,
        'xanchor': 'center',
        'yanchor': 'top'})

# fig.update_xaxes(title_text='Movies Titles')

# Set y-axes titles
fig.update_yaxes(title_text="Box Office $M", secondary_y=False)
fig.update_yaxes(title_text="Scores", secondary_y=True)

# fig.update_yaxes(title_text='Scores')
fig.update_layout(
    margin=dict(l=20, r=20, t=20, b=200)
    
)


fig.show()
In [28]:
# Getting a most profitable year
box = movies_df.groupby('date')['boxOffice'].sum()
box_df = pd.DataFrame(box)
box_df =box_df.reset_index()
box_df = box_df.sort_values(by=['boxOffice'], ascending=False)
box_df.head()
Out[28]:
date boxOffice
22 2018 2446.0
23 2019 1798.4
21 2017 1675.0
16 2012 1435.0
13 2008 1063.0
In [29]:
# Getting a most profitable movie
movies_df = movies_df.sort_values(by=['boxOffice'], ascending=False)
movies_df.head()
Out[29]:
rank title date rottenTomatoes boxOffice rewatchability totalScore image
47 3 Avengers: Endgame 2019 94% 858.0 7.50 212 https://hardrefreshcdn.com/public/media/superh...
48 2 Black Panther 2018 96% 700.0 9.60 213 https://hardrefreshcdn.com/public/media/superh...
41 9 Avengers: Infinity War 2018 84% 679.0 8.0 198 https://hardrefreshcdn.com/public/media/superh...
46 4 The Avengers 2012 92% 671.0 7.36 210 https://hardrefreshcdn.com/public/media/superh...
49 1 The Dark Knight 2008 94% 612.0 9.27 214 https://hardrefreshcdn.com/public/media/superh...
In [30]:
# Compare box office over the years
import plotly.express as px
df = movies_df
fig = px.scatter(df, x="date", y="boxOffice", size="boxOffice", color="boxOffice",
           hover_name="title", log_x=True, size_max=60)


fig.update_xaxes(title_text='year')
fig.update_yaxes(title_text='Box Office ($million)')

fig.update_layout(
    title={
        'text':'Box Office Over Time',
        'y':0.95,
        'x':0.4,
        'xanchor': 'center',
        'yanchor': 'top'}
)


fig.show()

Data Analysis

  1. The rotten tomatoes score didn't make a strong move with the time, while the total score gets higher with each year.
  2. Box office performance gets bigger with each year. The movie - Avengers: Endgame (2019) brought $858 M.
  3. For the last 15 years we can see an increasing production of superhero movies with much bigger box office every year. Looks like a money-making-machine for movie investors, which brings us to the conclusion - we are going to see even more superhero movies in the future.
In [31]:
# PART 3 =====================================
# Third sorce of data comes from omdb API for more information about our 50 movies. 
# In this section I am also using IMDbPY.
# IMDbPY is a Python package for retrieving and managing the data about movies and people.

# Note that the ?t= is a query param for the t-itle of the
# movie we want to search for.
url = "http://www.omdbapi.com/?t="
api_key = "&apikey=trilogy"

# Example of response for movie 'The Matrix'
response = requests.get(url + "The Matrix" + api_key)
print(response.url)
data = response.json()
pprint(data)
http://www.omdbapi.com/?t=The%20Matrix&apikey=trilogy
{'Actors': 'Keanu Reeves, Laurence Fishburne, Carrie-Anne Moss, Hugo Weaving',
 'Awards': 'Won 4 Oscars. Another 37 wins & 50 nominations.',
 'BoxOffice': 'N/A',
 'Country': 'USA',
 'DVD': '21 Sep 1999',
 'Director': 'Lana Wachowski, Lilly Wachowski',
 'Genre': 'Action, Sci-Fi',
 'Language': 'English',
 'Metascore': '73',
 'Plot': 'A computer hacker learns from mysterious rebels about the true '
         'nature of his reality and his role in the war against its '
         'controllers.',
 'Poster': 'https://m.media-amazon.com/images/M/MV5BNzQzOTk3OTAtNDQ0Zi00ZTVkLWI0MTEtMDllZjNkYzNjNTc4L2ltYWdlXkEyXkFqcGdeQXVyNjU0OTQ0OTY@._V1_SX300.jpg',
 'Production': 'Warner Bros. Pictures',
 'Rated': 'R',
 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '8.7/10'},
             {'Source': 'Rotten Tomatoes', 'Value': '88%'},
             {'Source': 'Metacritic', 'Value': '73/100'}],
 'Released': '31 Mar 1999',
 'Response': 'True',
 'Runtime': '136 min',
 'Title': 'The Matrix',
 'Type': 'movie',
 'Website': 'N/A',
 'Writer': 'Lilly Wachowski, Lana Wachowski',
 'Year': '1999',
 'imdbID': 'tt0133093',
 'imdbRating': '8.7',
 'imdbVotes': '1,624,177'}
In [32]:
import imdb
movies_titles = title
print(title)

# Creating a lists to store the data
imdbID=[]
id_clean = []
Title=[]
Year=[]
Production=[]
Plot=[]
Poster=[]
Actor = []
Role1 = []
Role2 = []
Actors = []
count = 0
['The Crow', 'Batman Forever', 'Hellboy II: The Golden Army', 'Thor: The Dark World', 'Man of Steel', 'Thor', 'Shazam!', 'X-Men: The Last Stand', 'Ant-Man', 'The Amazing Spider-Man', 'Captain America: The First Avenger', 'Superman Returns', 'X-Men: First Class', 'X-Men', 'Ant-Man and the Wasp', 'Aquaman', 'Spider-Man 3', 'Doctor Strange', 'Batman Returns', 'Batman Begins', 'X-Men: Days of Future Past', 'Spider-Man: Into the Spider-Verse', 'Superman II', 'X2: X-Men United', 'Iron Man 2', 'Deadpool 2', 'Logan', 'Captain Marvel', 'Captain America: The Winter Soldier', 'Avengers: Age of Ultron', 'Thor: Ragnarok', 'Guardians of the Galaxy Vol. 2', 'Batman', 'Deadpool', 'Iron Man 3', 'Spider-Man: Far From Home', 'Spider-Man: Homecoming', 'Guardians of the Galaxy', 'The Dark Knight Rises', 'Captain America: Civil War', 'Iron Man', 'Avengers: Infinity War', 'Wonder Woman', 'Spider-Man 2', 'Spider-Man', 'Superman', 'The Avengers', 'Avengers: Endgame', 'Black Panther', 'The Dark Knight']
In [33]:
# Performing a GET request similar to the one we executed
for i in movies_titles:
    # Error handling
        try:
            response = requests.get(url + i + api_key)
#             print(response.url)
            # Converting the response to JSON, and printing the result.
            data = response.json()
            print(data)
            imdbID_v = data['imdbID']
            id_v = imdbID_v[2:]
        
            
            Title_v = data['Title']
            Year_v = data['Year']
            Production_v = data['Production']
            Plot_v = data['Plot']
            Poster_v = data['Poster']
            Actors_v = data['Actors']
            
#             Getting actor and current role
            i =  imdb.IMDb(accessSystem='http')
            movie = i.get_movie(id_v)
            m_title = movie['title']
            print("=============")
            print(count)
            print(Poster_v)
            
            # Get the 1st Person object in the cast list
            cast = movie['cast'][0]
            cast
#             print(cast['name'])
            Actor_v = cast['name']
#             print(cast.currentRole)
            
            
            if len(cast.currentRole) == 1:
                Role1_v = str(cast.currentRole)
                Role2_v = 'None'
            elif len(cast.currentRole) == 2:
                Role1_v = str(cast.currentRole[0])
                Role2_v = str(cast.currentRole[1])
            else:
                Role1_v = 'None'
                Role2_v = 'None'
                
              # Get the 2nd Person object in the cast list
            second_cast = movie['cast'][1]
            second_cast
#             print(second_cast['name'])
#             Actor_v = second_cast['name']
                      

#             print(f"Movie title: {m_title}")
            print(f"Movie title: {Title_v}")
            print(m_title)
            print(id_v)
#             print(imdbID_v)
#             print(movie['cast'])
            print(Actors_v)
    
    
    
            imdbID.append(imdbID_v)
            id_clean.append(id_v)
            Title.append(Title_v)
            Year.append(Year_v)
            Actor.append(Actor_v)
            
            Role1.append(Role1_v)
            Role2.append(Role2_v)
#             print(cast.currentRole)
            print(f"{Actor_v} : {Role1_v} : {Role2_v}")
            print(f"Second_cast actor: {second_cast['name']} : {second_cast.currentRole}")
            print("===end=====")
            Production.append(Production_v)
            Plot.append(Plot_v)
            Poster.append(Poster_v)
            count +=1
        
        except AttributeError as e:
            print(e)
{'Title': 'The Crow', 'Year': '1994', 'Rated': 'R', 'Released': '13 May 1994', 'Runtime': '102 min', 'Genre': 'Action, Drama, Fantasy', 'Director': 'Alex Proyas', 'Writer': "James O'Barr (comic book series and comic strip), David J. Schow (screenplay), John Shirley (screenplay)", 'Actors': 'Brandon Lee, Rochelle Davis, Ernie Hudson, Michael Wincott', 'Plot': "A man brutally murdered comes back to life as an undead avenger of his and his fiancée's murder.", 'Language': 'English', 'Country': 'USA', 'Awards': '5 wins & 7 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BM2Y4ZGVhZjItNjU0OC00MDk1LWI4ZTktYTgwMWJkNDE5OTcxXkEyXkFqcGdeQXVyMTQxNzMzNDI@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.6/10'}, {'Source': 'Rotten Tomatoes', 'Value': '82%'}, {'Source': 'Metacritic', 'Value': '71/100'}], 'Metascore': '71', 'imdbRating': '7.6', 'imdbVotes': '162,523', 'imdbID': 'tt0109506', 'Type': 'movie', 'DVD': '01 Jan 1998', 'BoxOffice': 'N/A', 'Production': 'LionsGate Entertainment', 'Website': 'N/A', 'Response': 'True'}
=============
0
https://m.media-amazon.com/images/M/MV5BM2Y4ZGVhZjItNjU0OC00MDk1LWI4ZTktYTgwMWJkNDE5OTcxXkEyXkFqcGdeQXVyMTQxNzMzNDI@._V1_SX300.jpg
Movie title: The Crow
The Crow
0109506
Brandon Lee, Rochelle Davis, Ernie Hudson, Michael Wincott
Brandon Lee : Eric : None
Second_cast actor: Rochelle Davis : Sarah
===end=====
{'Title': 'Batman Forever', 'Year': '1995', 'Rated': 'PG-13', 'Released': '16 Jun 1995', 'Runtime': '121 min', 'Genre': 'Action, Adventure', 'Director': 'Joel Schumacher', 'Writer': 'Bob Kane (characters), Lee Batchler (story), Janet Scott Batchler (story), Lee Batchler (screenplay), Janet Scott Batchler (screenplay), Akiva Goldsman (screenplay)', 'Actors': 'Val Kilmer, Tommy Lee Jones, Jim Carrey, Nicole Kidman', 'Plot': 'Batman must battle former district attorney Harvey Dent, who is now Two-Face and Edward Nygma, The Riddler with help from an amorous psychologist and a young circus acrobat who becomes his sidekick, Robin.', 'Language': 'English', 'Country': 'USA, UK', 'Awards': 'Nominated for 3 Oscars. Another 10 wins & 22 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDdjYmFiYWEtYzBhZS00YTZkLWFlODgtY2I5MDE0NzZmMDljXkEyXkFqcGdeQXVyMTMxODk2OTU@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '5.4/10'}, {'Source': 'Rotten Tomatoes', 'Value': '39%'}, {'Source': 'Metacritic', 'Value': '51/100'}], 'Metascore': '51', 'imdbRating': '5.4', 'imdbVotes': '230,252', 'imdbID': 'tt0112462', 'Type': 'movie', 'DVD': '27 Aug 1997', 'BoxOffice': 'N/A', 'Production': 'Warner Bros. Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
1
https://m.media-amazon.com/images/M/MV5BNDdjYmFiYWEtYzBhZS00YTZkLWFlODgtY2I5MDE0NzZmMDljXkEyXkFqcGdeQXVyMTMxODk2OTU@._V1_SX300.jpg
Movie title: Batman Forever
Batman Forever
0112462
Val Kilmer, Tommy Lee Jones, Jim Carrey, Nicole Kidman
Val Kilmer : Batman : Bruce Wayne
Second_cast actor: Tommy Lee Jones : Harvey Two-Face / Harvey Dent
===end=====
{'Title': 'Hellboy II: The Golden Army', 'Year': '2008', 'Rated': 'PG-13', 'Released': '11 Jul 2008', 'Runtime': '120 min', 'Genre': 'Action, Adventure, Fantasy, Horror, Sci-Fi', 'Director': 'Guillermo del Toro', 'Writer': 'Guillermo del Toro (screenplay), Guillermo del Toro (story), Mike Mignola (story), Mike Mignola (comic book)', 'Actors': 'Ron Perlman, Selma Blair, Doug Jones, John Alexander', 'Plot': 'The mythical world starts a rebellion against humanity in order to rule the Earth, so Hellboy and his team must save the world from the rebellious creatures.', 'Language': 'English, Scottish Gaelic', 'Country': 'USA, Germany, Hungary', 'Awards': 'Nominated for 1 Oscar. Another 5 wins & 29 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMjA5NzgyMjc2Nl5BMl5BanBnXkFtZTcwOTU3MDI3MQ@@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.0/10'}, {'Source': 'Rotten Tomatoes', 'Value': '86%'}, {'Source': 'Metacritic', 'Value': '78/100'}], 'Metascore': '78', 'imdbRating': '7.0', 'imdbVotes': '251,908', 'imdbID': 'tt0411477', 'Type': 'movie', 'DVD': '11 Nov 2008', 'BoxOffice': '$75,754,670', 'Production': 'Universal Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
2
https://m.media-amazon.com/images/M/MV5BMjA5NzgyMjc2Nl5BMl5BanBnXkFtZTcwOTU3MDI3MQ@@._V1_SX300.jpg
Movie title: Hellboy II: The Golden Army
Hellboy II: The Golden Army
0411477
Ron Perlman, Selma Blair, Doug Jones, John Alexander
Ron Perlman : Hellboy : None
Second_cast actor: Selma Blair : Liz Sherman
===end=====
{'Title': 'Thor: The Dark World', 'Year': '2013', 'Rated': 'PG-13', 'Released': '08 Nov 2013', 'Runtime': '112 min', 'Genre': 'Action, Adventure, Fantasy', 'Director': 'Alan Taylor', 'Writer': 'Christopher L. Yost (screenplay by), Christopher Markus (screenplay by), Stephen McFeely (screenplay by), Don Payne (story by), Robert Rodat (story by), Stan Lee (based on the Marvel comics by), Larry Lieber (based on the Marvel comics by), Jack Kirby (based on the Marvel comics by), Walter Simonson (character created by: Malekith)', 'Actors': 'Chris Hemsworth, Natalie Portman, Tom Hiddleston, Anthony Hopkins', 'Plot': 'When the Dark Elves attempt to plunge the universe into darkness, Thor must embark on a perilous and personal journey that will reunite him with doctor Jane Foster.', 'Language': 'English', 'Country': 'USA', 'Awards': '3 wins & 21 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTQyNzAwOTUxOF5BMl5BanBnXkFtZTcwMTE0OTc5OQ@@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '6.9/10'}, {'Source': 'Rotten Tomatoes', 'Value': '66%'}, {'Source': 'Metacritic', 'Value': '54/100'}], 'Metascore': '54', 'imdbRating': '6.9', 'imdbVotes': '578,201', 'imdbID': 'tt1981115', 'Type': 'movie', 'DVD': '25 Feb 2014', 'BoxOffice': '$206,360,018', 'Production': 'Walt Disney Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
3
https://m.media-amazon.com/images/M/MV5BMTQyNzAwOTUxOF5BMl5BanBnXkFtZTcwMTE0OTc5OQ@@._V1_SX300.jpg
Movie title: Thor: The Dark World
Thor: The Dark World
1981115
Chris Hemsworth, Natalie Portman, Tom Hiddleston, Anthony Hopkins
Chris Hemsworth : Thor : None
Second_cast actor: Natalie Portman : Jane Foster
===end=====
{'Title': 'Man of Steel', 'Year': '2013', 'Rated': 'PG-13', 'Released': '14 Jun 2013', 'Runtime': '143 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Zack Snyder', 'Writer': 'David S. Goyer (screenplay), David S. Goyer (story), Christopher Nolan (story), Jerry Siegel (Superman created by), Joe Shuster (Superman created by)', 'Actors': 'Henry Cavill, Amy Adams, Michael Shannon, Diane Lane', 'Plot': 'An alien child is evacuated from his dying world and sent to Earth to live among humans. His peace is threatened, when other survivors of his home planet invade Earth.', 'Language': 'English', 'Country': 'USA, UK', 'Awards': '7 wins & 46 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTk5ODk1NDkxMF5BMl5BanBnXkFtZTcwNTA5OTY0OQ@@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.0/10'}, {'Source': 'Rotten Tomatoes', 'Value': '56%'}, {'Source': 'Metacritic', 'Value': '55/100'}], 'Metascore': '55', 'imdbRating': '7.0', 'imdbVotes': '675,921', 'imdbID': 'tt0770828', 'Type': 'movie', 'DVD': '12 Nov 2013', 'BoxOffice': '$291,021,565', 'Production': 'Warner Bros. Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
4
https://m.media-amazon.com/images/M/MV5BMTk5ODk1NDkxMF5BMl5BanBnXkFtZTcwNTA5OTY0OQ@@._V1_SX300.jpg
Movie title: Man of Steel
Man of Steel
0770828
Henry Cavill, Amy Adams, Michael Shannon, Diane Lane
Henry Cavill : Clark Kent : Kal-El
Second_cast actor: Amy Adams : Lois Lane
===end=====
{'Title': 'Thor', 'Year': '2011', 'Rated': 'PG-13', 'Released': '06 May 2011', 'Runtime': '115 min', 'Genre': 'Action, Adventure, Fantasy', 'Director': 'Kenneth Branagh', 'Writer': 'Ashley Miller (screenplay), Zack Stentz (screenplay), Don Payne (screenplay), J. Michael Straczynski (story), Mark Protosevich (story), Stan Lee (comic book), Larry Lieber (comic book), Jack Kirby (comic book)', 'Actors': 'Chris Hemsworth, Natalie Portman, Tom Hiddleston, Anthony Hopkins', 'Plot': 'The powerful but arrogant god Thor is cast out of Asgard to live amongst humans in Midgard (Earth), where he soon becomes one of their finest defenders.', 'Language': 'English', 'Country': 'USA', 'Awards': '5 wins & 30 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BOGE4NzU1YTAtNzA3Mi00ZTA2LTg2YmYtMDJmMThiMjlkYjg2XkEyXkFqcGdeQXVyNTgzMDMzMTg@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.0/10'}, {'Source': 'Rotten Tomatoes', 'Value': '77%'}, {'Source': 'Metacritic', 'Value': '57/100'}], 'Metascore': '57', 'imdbRating': '7.0', 'imdbVotes': '725,928', 'imdbID': 'tt0800369', 'Type': 'movie', 'DVD': '13 Sep 2011', 'BoxOffice': '$181,015,141', 'Production': 'Paramount Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
5
https://m.media-amazon.com/images/M/MV5BOGE4NzU1YTAtNzA3Mi00ZTA2LTg2YmYtMDJmMThiMjlkYjg2XkEyXkFqcGdeQXVyNTgzMDMzMTg@._V1_SX300.jpg
Movie title: Thor
Thor
0800369
Chris Hemsworth, Natalie Portman, Tom Hiddleston, Anthony Hopkins
Chris Hemsworth : Thor : None
Second_cast actor: Natalie Portman : Jane Foster
===end=====
{'Title': 'Shazam!', 'Year': '2019', 'Rated': 'PG-13', 'Released': '05 Apr 2019', 'Runtime': '132 min', 'Genre': 'Action, Adventure, Comedy, Fantasy', 'Director': 'David F. Sandberg', 'Writer': 'Henry Gayden (screenplay by), Henry Gayden (story by), Darren Lemke (story by), Bill Parker (Shazam created by), C.C. Beck (Shazam created by)', 'Actors': 'Zachary Levi, Mark Strong, Asher Angel, Jack Dylan Grazer', 'Plot': 'A newly fostered young boy in search of his mother instead finds unexpected super powers and soon gains a powerful enemy.', 'Language': 'English, Spanish', 'Country': 'USA, Canada', 'Awards': '21 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYTE0Yjc1NzUtMjFjMC00Y2I3LTg3NGYtNGRlMGJhYThjMTJmXkEyXkFqcGdeQXVyNTI4MzE4MDU@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.1/10'}, {'Source': 'Rotten Tomatoes', 'Value': '90%'}, {'Source': 'Metacritic', 'Value': '71/100'}], 'Metascore': '71', 'imdbRating': '7.1', 'imdbVotes': '235,683', 'imdbID': 'tt0448115', 'Type': 'movie', 'DVD': '02 Jul 2019', 'BoxOffice': 'N/A', 'Production': 'New Line Cinema', 'Website': 'N/A', 'Response': 'True'}
=============
6
https://m.media-amazon.com/images/M/MV5BYTE0Yjc1NzUtMjFjMC00Y2I3LTg3NGYtNGRlMGJhYThjMTJmXkEyXkFqcGdeQXVyNTI4MzE4MDU@._V1_SX300.jpg
Movie title: Shazam!
Shazam!
0448115
Zachary Levi, Mark Strong, Asher Angel, Jack Dylan Grazer
Zachary Levi : Shazam : None
Second_cast actor: Mark Strong : Dr. Sivana
===end=====
{'Title': 'X-Men: The Last Stand', 'Year': '2006', 'Rated': 'PG-13', 'Released': '26 May 2006', 'Runtime': '104 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Brett Ratner', 'Writer': 'Simon Kinberg, Zak Penn', 'Actors': 'Hugh Jackman, Halle Berry, Ian McKellen, Patrick Stewart', 'Plot': 'The human government develops a cure for mutations, and Jean Gray becomes a darker uncontrollable persona called the Phoenix who allies with Magneto, causing escalation into an all-out battle for the X-Men.', 'Language': 'English', 'Country': 'Canada, USA, UK', 'Awards': '7 wins & 37 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDBhNDJiMWEtOTg4Yi00NTYzLWEzOGMtMjNmNjAxNTBlMzY3XkEyXkFqcGdeQXVyNTIzOTk5ODM@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '6.7/10'}, {'Source': 'Rotten Tomatoes', 'Value': '57%'}, {'Source': 'Metacritic', 'Value': '58/100'}], 'Metascore': '58', 'imdbRating': '6.7', 'imdbVotes': '474,027', 'imdbID': 'tt0376994', 'Type': 'movie', 'DVD': '03 Oct 2006', 'BoxOffice': '$234,300,000', 'Production': '20th Century Fox', 'Website': 'N/A', 'Response': 'True'}
=============
7
https://m.media-amazon.com/images/M/MV5BNDBhNDJiMWEtOTg4Yi00NTYzLWEzOGMtMjNmNjAxNTBlMzY3XkEyXkFqcGdeQXVyNTIzOTk5ODM@._V1_SX300.jpg
Movie title: X-Men: The Last Stand
X-Men: The Last Stand
0376994
Hugh Jackman, Halle Berry, Ian McKellen, Patrick Stewart
Hugh Jackman : Logan : Wolverine
Second_cast actor: Halle Berry : Ororo Munroe / Storm
===end=====
{'Title': 'Ant-Man', 'Year': '2015', 'Rated': 'PG-13', 'Released': '17 Jul 2015', 'Runtime': '117 min', 'Genre': 'Action, Adventure, Comedy, Sci-Fi', 'Director': 'Peyton Reed', 'Writer': 'Edgar Wright (screenplay by), Joe Cornish (screenplay by), Adam McKay (screenplay by), Paul Rudd (screenplay by), Edgar Wright (story by), Joe Cornish (story by), Stan Lee (based on the Marvel comics by), Larry Lieber (based on the Marvel comics by), Jack Kirby (based on the Marvel comics by)', 'Actors': 'Paul Rudd, Michael Douglas, Evangeline Lilly, Corey Stoll', 'Plot': 'Armed with a super-suit with the astonishing ability to shrink in scale but increase in strength, cat burglar Scott Lang must embrace his inner hero and help his mentor, Dr. Hank Pym, plan and pull off a heist that will save the world.', 'Language': 'English', 'Country': 'USA', 'Awards': 'Nominated for 1 BAFTA Film Award. Another 4 wins & 33 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMjM2NTQ5Mzc2M15BMl5BanBnXkFtZTgwNTcxMDI2NTE@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.3/10'}, {'Source': 'Rotten Tomatoes', 'Value': '83%'}, {'Source': 'Metacritic', 'Value': '64/100'}], 'Metascore': '64', 'imdbRating': '7.3', 'imdbVotes': '548,178', 'imdbID': 'tt0478970', 'Type': 'movie', 'DVD': '08 Dec 2015', 'BoxOffice': '$138,002,223', 'Production': 'Disney/Marvel', 'Website': 'N/A', 'Response': 'True'}
=============
8
https://m.media-amazon.com/images/M/MV5BMjM2NTQ5Mzc2M15BMl5BanBnXkFtZTgwNTcxMDI2NTE@._V1_SX300.jpg
Movie title: Ant-Man
Ant-Man
0478970
Paul Rudd, Michael Douglas, Evangeline Lilly, Corey Stoll
Paul Rudd : Scott Lang : Ant-Man
Second_cast actor: Michael Douglas : Dr. Hank Pym
===end=====
{'Title': 'The Amazing Spider-Man', 'Year': '2012', 'Rated': 'PG-13', 'Released': '03 Jul 2012', 'Runtime': '136 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Marc Webb', 'Writer': 'James Vanderbilt (screenplay), Alvin Sargent (screenplay), Steve Kloves (screenplay), James Vanderbilt (story), Stan Lee (based on the Marvel comic book by), Steve Ditko (based on the Marvel comic book by)', 'Actors': 'Andrew Garfield, Emma Stone, Rhys Ifans, Denis Leary', 'Plot': 'After Peter Parker is bitten by a genetically altered spider, he gains newfound, spider-like powers and ventures out to save the city from the machinations of a mysterious reptilian foe.', 'Language': 'English', 'Country': 'USA', 'Awards': '2 wins & 31 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMjMyOTM4MDMxNV5BMl5BanBnXkFtZTcwNjIyNzExOA@@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '6.9/10'}, {'Source': 'Rotten Tomatoes', 'Value': '73%'}, {'Source': 'Metacritic', 'Value': '66/100'}], 'Metascore': '66', 'imdbRating': '6.9', 'imdbVotes': '548,471', 'imdbID': 'tt0948470', 'Type': 'movie', 'DVD': '09 Nov 2012', 'BoxOffice': '$262,030,663', 'Production': 'Sony Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
9
https://m.media-amazon.com/images/M/MV5BMjMyOTM4MDMxNV5BMl5BanBnXkFtZTcwNjIyNzExOA@@._V1_SX300.jpg
Movie title: The Amazing Spider-Man
The Amazing Spider-Man
0948470
Andrew Garfield, Emma Stone, Rhys Ifans, Denis Leary
Andrew Garfield : Spider-Man : Peter Parker
Second_cast actor: Emma Stone : Gwen Stacy
===end=====
{'Title': 'Captain America: The First Avenger', 'Year': '2011', 'Rated': 'PG-13', 'Released': '22 Jul 2011', 'Runtime': '124 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Joe Johnston', 'Writer': 'Christopher Markus (screenplay), Stephen McFeely (screenplay), Joe Simon (comic books), Jack Kirby (comic books)', 'Actors': 'Chris Evans, Hayley Atwell, Sebastian Stan, Tommy Lee Jones', 'Plot': 'Steve Rogers, a rejected military soldier, transforms into Captain America after taking a dose of a "Super-Soldier serum". But being Captain America comes at a price as he attempts to take down a war monger and a terrorist organization.', 'Language': 'English, Norwegian, French', 'Country': 'USA', 'Awards': '4 wins & 46 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTYzOTc2NzU3N15BMl5BanBnXkFtZTcwNjY3MDE3NQ@@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '6.9/10'}, {'Source': 'Rotten Tomatoes', 'Value': '80%'}, {'Source': 'Metacritic', 'Value': '66/100'}], 'Metascore': '66', 'imdbRating': '6.9', 'imdbVotes': '718,921', 'imdbID': 'tt0458339', 'Type': 'movie', 'DVD': '25 Oct 2011', 'BoxOffice': '$176,636,816', 'Production': 'Paramount Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
10
https://m.media-amazon.com/images/M/MV5BMTYzOTc2NzU3N15BMl5BanBnXkFtZTcwNjY3MDE3NQ@@._V1_SX300.jpg
Movie title: Captain America: The First Avenger
Captain America: The First Avenger
0458339
Chris Evans, Hayley Atwell, Sebastian Stan, Tommy Lee Jones
Chris Evans : Captain America : Steve Rogers
Second_cast actor: Hayley Atwell : Peggy Carter
===end=====
{'Title': 'Superman Returns', 'Year': '2006', 'Rated': 'PG-13', 'Released': '28 Jun 2006', 'Runtime': '154 min', 'Genre': 'Action, Sci-Fi', 'Director': 'Bryan Singer', 'Writer': 'Michael Dougherty (screenplay), Dan Harris (screenplay), Bryan Singer (story), Michael Dougherty (story), Dan Harris (story), Jerry Siegel (characters), Joe Shuster (characters)', 'Actors': 'Brandon Routh, Kate Bosworth, Kevin Spacey, James Marsden', 'Plot': 'Superman returns to Earth after spending five years in space examining his homeworld Krypton. But he finds things have changed while he was gone, and he must once again prove himself important to the world.', 'Language': 'English, German, French', 'Country': 'USA', 'Awards': 'Nominated for 1 Oscar. Another 12 wins & 41 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNzY2ZDQ2MTctYzlhOC00MWJhLTgxMmItMDgzNDQwMDdhOWI2XkEyXkFqcGdeQXVyNjc1NTYyMjg@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '6.0/10'}, {'Source': 'Rotten Tomatoes', 'Value': '75%'}, {'Source': 'Metacritic', 'Value': '72/100'}], 'Metascore': '72', 'imdbRating': '6.0', 'imdbVotes': '267,446', 'imdbID': 'tt0348150', 'Type': 'movie', 'DVD': '28 Nov 2006', 'BoxOffice': '$200,100,000', 'Production': 'Warner Bros. Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
11
https://m.media-amazon.com/images/M/MV5BNzY2ZDQ2MTctYzlhOC00MWJhLTgxMmItMDgzNDQwMDdhOWI2XkEyXkFqcGdeQXVyNjc1NTYyMjg@._V1_SX300.jpg
Movie title: Superman Returns
Superman Returns
0348150
Brandon Routh, Kate Bosworth, Kevin Spacey, James Marsden
Brandon Routh : Clark Kent : Superman
Second_cast actor: Kate Bosworth : Lois Lane
===end=====
{'Title': 'X-Men: First Class', 'Year': '2011', 'Rated': 'PG-13', 'Released': '03 Jun 2011', 'Runtime': '131 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Matthew Vaughn', 'Writer': 'Ashley Miller (screenplay by), Zack Stentz (screenplay by), Jane Goldman (screenplay by), Matthew Vaughn (screenplay by), Sheldon Turner (story by), Bryan Singer (story by)', 'Actors': 'James McAvoy, Laurence Belcher, Michael Fassbender, Bill Milner', 'Plot': "In the 1960s, superpowered humans Charles Xavier and Erik Lensherr work together to find others like them, but Erik's vengeful pursuit of an ambitious mutant who ruined his life causes a schism to divide them.", 'Language': 'English, German, French, Spanish, Russian', 'Country': 'USA, UK', 'Awards': '21 wins & 39 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTg5OTMxNzk4Nl5BMl5BanBnXkFtZTcwOTk1MjAwNQ@@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.7/10'}, {'Source': 'Rotten Tomatoes', 'Value': '86%'}, {'Source': 'Metacritic', 'Value': '65/100'}], 'Metascore': '65', 'imdbRating': '7.7', 'imdbVotes': '634,061', 'imdbID': 'tt1270798', 'Type': 'movie', 'DVD': '09 Sep 2011', 'BoxOffice': '$145,300,000', 'Production': '20th Century Fox', 'Website': 'N/A', 'Response': 'True'}
=============
12
https://m.media-amazon.com/images/M/MV5BMTg5OTMxNzk4Nl5BMl5BanBnXkFtZTcwOTk1MjAwNQ@@._V1_SX300.jpg
Movie title: X-Men: First Class
X-Men: First Class
1270798
James McAvoy, Laurence Belcher, Michael Fassbender, Bill Milner
James McAvoy : Charles Xavier : None
Second_cast actor: Laurence Belcher : Charles Xavier
===end=====
{'Title': 'X-Men', 'Year': '2000', 'Rated': 'PG-13', 'Released': '14 Jul 2000', 'Runtime': '104 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Bryan Singer', 'Writer': 'Tom DeSanto (story), Bryan Singer (story), David Hayter (screenplay)', 'Actors': 'Hugh Jackman, Patrick Stewart, Ian McKellen, Famke Janssen', 'Plot': 'In a world where mutants (evolved super-powered humans) exist and are discriminated against, two groups form for an inevitable clash: the supremacist Brotherhood, and the pacifist X-Men.', 'Language': 'English', 'Country': 'USA', 'Awards': '13 wins & 27 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BZmIyMDk5NGYtYjQ5NS00ZWQxLTg2YzQtZDk1ZmM4ZDBlN2E3XkEyXkFqcGdeQXVyMTQxNzMzNDI@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.4/10'}, {'Source': 'Rotten Tomatoes', 'Value': '81%'}, {'Source': 'Metacritic', 'Value': '64/100'}], 'Metascore': '64', 'imdbRating': '7.4', 'imdbVotes': '559,246', 'imdbID': 'tt0120903', 'Type': 'movie', 'DVD': '21 Nov 2000', 'BoxOffice': '$156,164,829', 'Production': '20th Century Fox', 'Website': 'N/A', 'Response': 'True'}
=============
13
https://m.media-amazon.com/images/M/MV5BZmIyMDk5NGYtYjQ5NS00ZWQxLTg2YzQtZDk1ZmM4ZDBlN2E3XkEyXkFqcGdeQXVyMTQxNzMzNDI@._V1_SX300.jpg
Movie title: X-Men
X-Men
0120903
Hugh Jackman, Patrick Stewart, Ian McKellen, Famke Janssen
Hugh Jackman : Logan : Wolverine
Second_cast actor: Patrick Stewart : Professor Charles Xavier
===end=====
{'Title': 'Ant-Man and the Wasp', 'Year': '2018', 'Rated': 'PG-13', 'Released': '06 Jul 2018', 'Runtime': '118 min', 'Genre': 'Action, Adventure, Comedy, Sci-Fi', 'Director': 'Peyton Reed', 'Writer': 'Chris McKenna, Erik Sommers, Paul Rudd, Andrew Barrer, Gabriel Ferrari, Stan Lee (based on the Marvel Comics by), Larry Lieber (based on the Marvel Comics by), Jack Kirby (based on the Marvel Comics by)', 'Actors': 'Paul Rudd, Evangeline Lilly, Michael Peña, Walton Goggins', 'Plot': 'As Scott Lang balances being both a superhero and a father, Hope van Dyne and Dr. Hank Pym present an urgent new mission that finds the Ant-Man fighting alongside The Wasp to uncover secrets from their past.', 'Language': 'English, Spanish', 'Country': 'USA', 'Awards': '18 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYjcyYTk0N2YtMzc4ZC00Y2E0LWFkNDgtNjE1MzZmMGE1YjY1XkEyXkFqcGdeQXVyMTMxODk2OTU@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.1/10'}, {'Source': 'Rotten Tomatoes', 'Value': '87%'}, {'Source': 'Metacritic', 'Value': '70/100'}], 'Metascore': '70', 'imdbRating': '7.1', 'imdbVotes': '292,457', 'imdbID': 'tt5095030', 'Type': 'movie', 'DVD': '16 Oct 2018', 'BoxOffice': 'N/A', 'Production': 'Walt Disney Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
14
https://m.media-amazon.com/images/M/MV5BYjcyYTk0N2YtMzc4ZC00Y2E0LWFkNDgtNjE1MzZmMGE1YjY1XkEyXkFqcGdeQXVyMTMxODk2OTU@._V1_SX300.jpg
Movie title: Ant-Man and the Wasp
Ant-Man and the Wasp
5095030
Paul Rudd, Evangeline Lilly, Michael Peña, Walton Goggins
Paul Rudd : Scott Lang : Ant-Man
Second_cast actor: Evangeline Lilly : Hope Van Dyne / Wasp
===end=====
{'Title': 'Aquaman', 'Year': '2018', 'Rated': 'PG-13', 'Released': '21 Dec 2018', 'Runtime': '143 min', 'Genre': 'Action, Adventure, Fantasy, Sci-Fi', 'Director': 'James Wan', 'Writer': 'David Leslie Johnson-McGoldrick (screenplay by), Will Beall (screenplay by), Geoff Johns (story by), James Wan (story by), Will Beall (story by), Paul Norris (Aquaman created by), Mort Weisinger (Aquaman created by)', 'Actors': 'Jason Momoa, Amber Heard, Willem Dafoe, Patrick Wilson', 'Plot': 'Arthur Curry (Jason Momoa), the human-born heir to the underwater kingdom of Atlantis, goes on a quest to prevent a war between the worlds of ocean and land.', 'Language': 'English, Russian, Maori, Italian', 'Country': 'USA, Australia', 'Awards': '2 wins & 38 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BOTk5ODg0OTU5M15BMl5BanBnXkFtZTgwMDQ3MDY3NjM@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.0/10'}, {'Source': 'Rotten Tomatoes', 'Value': '65%'}, {'Source': 'Metacritic', 'Value': '55/100'}], 'Metascore': '55', 'imdbRating': '7.0', 'imdbVotes': '341,645', 'imdbID': 'tt1477834', 'Type': 'movie', 'DVD': 'N/A', 'BoxOffice': 'N/A', 'Production': 'Warner Bros. Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
15
https://m.media-amazon.com/images/M/MV5BOTk5ODg0OTU5M15BMl5BanBnXkFtZTgwMDQ3MDY3NjM@._V1_SX300.jpg
Movie title: Aquaman
Aquaman
1477834
Jason Momoa, Amber Heard, Willem Dafoe, Patrick Wilson
Jason Momoa : Arthur : None
Second_cast actor: Amber Heard : Mera
===end=====
{'Title': 'Spider-Man 3', 'Year': '2007', 'Rated': 'PG-13', 'Released': '04 May 2007', 'Runtime': '139 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Sam Raimi', 'Writer': 'Sam Raimi (screenplay), Ivan Raimi (screenplay), Alvin Sargent (screenplay), Sam Raimi (screen story), Ivan Raimi (screen story), Stan Lee (Marvel comic book), Steve Ditko (Marvel comic book)', 'Actors': 'Tobey Maguire, Kirsten Dunst, James Franco, Thomas Haden Church', 'Plot': 'A strange black entity from another world bonds with Peter Parker and causes inner turmoil as he contends with new villains, temptations, and revenge.', 'Language': 'English, French', 'Country': 'USA', 'Awards': 'Nominated for 1 BAFTA Film Award. Another 3 wins & 32 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYTk3MDljOWQtNGI2My00OTEzLTlhYjQtOTQ4ODM2MzUwY2IwXkEyXkFqcGdeQXVyNTIzOTk5ODM@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '6.2/10'}, {'Source': 'Rotten Tomatoes', 'Value': '63%'}, {'Source': 'Metacritic', 'Value': '59/100'}], 'Metascore': '59', 'imdbRating': '6.2', 'imdbVotes': '487,566', 'imdbID': 'tt0413300', 'Type': 'movie', 'DVD': '30 Oct 2007', 'BoxOffice': '$336,530,303', 'Production': 'Sony Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
16
https://m.media-amazon.com/images/M/MV5BYTk3MDljOWQtNGI2My00OTEzLTlhYjQtOTQ4ODM2MzUwY2IwXkEyXkFqcGdeQXVyNTIzOTk5ODM@._V1_SX300.jpg
Movie title: Spider-Man 3
Spider-Man 3
0413300
Tobey Maguire, Kirsten Dunst, James Franco, Thomas Haden Church
Tobey Maguire : Spider-Man : Peter Parker
Second_cast actor: Kirsten Dunst : Mary Jane Watson
===end=====
{'Title': 'Doctor Strange', 'Year': '2016', 'Rated': 'PG-13', 'Released': '04 Nov 2016', 'Runtime': '115 min', 'Genre': 'Action, Adventure, Fantasy, Sci-Fi', 'Director': 'Scott Derrickson', 'Writer': 'Jon Spaihts, Scott Derrickson, C. Robert Cargill, Stan Lee (based on the Marvel comics by), Steve Ditko (based on the Marvel comics by)', 'Actors': 'Benedict Cumberbatch, Chiwetel Ejiofor, Rachel McAdams, Benedict Wong', 'Plot': 'While on a journey of physical and spiritual healing, a brilliant neurosurgeon is drawn into the world of the mystic arts.', 'Language': 'English', 'Country': 'USA', 'Awards': 'Nominated for 1 Oscar. Another 20 wins & 65 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNjgwNzAzNjk1Nl5BMl5BanBnXkFtZTgwMzQ2NjI1OTE@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.5/10'}, {'Source': 'Rotten Tomatoes', 'Value': '89%'}, {'Source': 'Metacritic', 'Value': '72/100'}], 'Metascore': '72', 'imdbRating': '7.5', 'imdbVotes': '575,109', 'imdbID': 'tt1211837', 'Type': 'movie', 'DVD': '28 Feb 2017', 'BoxOffice': '$232,630,718', 'Production': 'Walt Disney Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
17
https://m.media-amazon.com/images/M/MV5BNjgwNzAzNjk1Nl5BMl5BanBnXkFtZTgwMzQ2NjI1OTE@._V1_SX300.jpg
Movie title: Doctor Strange
Doctor Strange
1211837
Benedict Cumberbatch, Chiwetel Ejiofor, Rachel McAdams, Benedict Wong
Benedict Cumberbatch : Dr. Stephen Strange : None
Second_cast actor: Chiwetel Ejiofor : Mordo
===end=====
{'Title': 'Batman Returns', 'Year': '1992', 'Rated': 'PG-13', 'Released': '19 Jun 1992', 'Runtime': '126 min', 'Genre': 'Action, Crime, Fantasy', 'Director': 'Tim Burton', 'Writer': 'Bob Kane (Batman characters), Daniel Waters (story), Sam Hamm (story), Daniel Waters (screenplay)', 'Actors': 'Michael Keaton, Danny DeVito, Michelle Pfeiffer, Christopher Walken', 'Plot': 'Batman returns to the big screen when a deformed man calling himself the Penguin wreaks havoc across Gotham with the help of a cruel businessman.', 'Language': 'English', 'Country': 'USA, UK', 'Awards': 'Nominated for 2 Oscars. Another 2 wins & 27 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BOGZmYzVkMmItM2NiOS00MDI3LWI4ZWQtMTg0YWZkODRkMmViXkEyXkFqcGdeQXVyODY0NzcxNw@@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.0/10'}, {'Source': 'Rotten Tomatoes', 'Value': '80%'}, {'Source': 'Metacritic', 'Value': '68/100'}], 'Metascore': '68', 'imdbRating': '7.0', 'imdbVotes': '267,581', 'imdbID': 'tt0103776', 'Type': 'movie', 'DVD': '29 Apr 1997', 'BoxOffice': 'N/A', 'Production': 'Warner Bros. Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
18
https://m.media-amazon.com/images/M/MV5BOGZmYzVkMmItM2NiOS00MDI3LWI4ZWQtMTg0YWZkODRkMmViXkEyXkFqcGdeQXVyODY0NzcxNw@@._V1_SX300.jpg
Movie title: Batman Returns
Batman Returns
0103776
Michael Keaton, Danny DeVito, Michelle Pfeiffer, Christopher Walken
Michael Keaton : Batman : Bruce Wayne
Second_cast actor: Danny DeVito : Penguin
===end=====
{'Title': 'Batman Begins', 'Year': '2005', 'Rated': 'PG-13', 'Released': '15 Jun 2005', 'Runtime': '140 min', 'Genre': 'Action, Adventure', 'Director': 'Christopher Nolan', 'Writer': 'Bob Kane (characters), David S. Goyer (story), Christopher Nolan (screenplay), David S. Goyer (screenplay)', 'Actors': 'Christian Bale, Michael Caine, Liam Neeson, Katie Holmes', 'Plot': 'After training with his mentor, Batman begins his fight to free crime-ridden Gotham City from corruption.', 'Language': 'English, Mandarin', 'Country': 'USA, UK', 'Awards': 'Nominated for 1 Oscar. Another 14 wins & 72 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BZmUwNGU2ZmItMmRiNC00MjhlLTg5YWUtODMyNzkxODYzMmZlXkEyXkFqcGdeQXVyNTIzOTk5ODM@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '8.2/10'}, {'Source': 'Rotten Tomatoes', 'Value': '84%'}, {'Source': 'Metacritic', 'Value': '70/100'}], 'Metascore': '70', 'imdbRating': '8.2', 'imdbVotes': '1,272,033', 'imdbID': 'tt0372784', 'Type': 'movie', 'DVD': '18 Oct 2005', 'BoxOffice': '$204,100,000', 'Production': 'Warner Bros. Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
19
https://m.media-amazon.com/images/M/MV5BZmUwNGU2ZmItMmRiNC00MjhlLTg5YWUtODMyNzkxODYzMmZlXkEyXkFqcGdeQXVyNTIzOTk5ODM@._V1_SX300.jpg
Movie title: Batman Begins
Batman Begins
0372784
Christian Bale, Michael Caine, Liam Neeson, Katie Holmes
Christian Bale : Bruce Wayne : Batman
Second_cast actor: Michael Caine : Alfred
===end=====
{'Title': 'X-Men: Days of Future Past', 'Year': '2014', 'Rated': 'PG-13', 'Released': '23 May 2014', 'Runtime': '132 min', 'Genre': 'Action, Adventure, Sci-Fi, Thriller', 'Director': 'Bryan Singer', 'Writer': 'Simon Kinberg (screenplay by), Jane Goldman (story by), Simon Kinberg (story by), Matthew Vaughn (story by)', 'Actors': 'Hugh Jackman, James McAvoy, Michael Fassbender, Jennifer Lawrence', 'Plot': 'The X-Men send Wolverine to the past in a desperate effort to change history and prevent an event that results in doom for both humans and mutants.', 'Language': 'English, Vietnamese, French', 'Country': 'USA, UK, Canada', 'Awards': 'Nominated for 1 Oscar. Another 16 wins & 47 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BZGIzNWYzN2YtMjcwYS00YjQ3LWI2NjMtOTNiYTUyYjE2MGNkXkEyXkFqcGdeQXVyMTQxNzMzNDI@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '8.0/10'}, {'Source': 'Rotten Tomatoes', 'Value': '90%'}, {'Source': 'Metacritic', 'Value': '75/100'}], 'Metascore': '75', 'imdbRating': '8.0', 'imdbVotes': '647,269', 'imdbID': 'tt1877832', 'Type': 'movie', 'DVD': '14 Oct 2014', 'BoxOffice': '$199,305,306', 'Production': '20th Century Fox', 'Website': 'N/A', 'Response': 'True'}
=============
20
https://m.media-amazon.com/images/M/MV5BZGIzNWYzN2YtMjcwYS00YjQ3LWI2NjMtOTNiYTUyYjE2MGNkXkEyXkFqcGdeQXVyMTQxNzMzNDI@._V1_SX300.jpg
Movie title: X-Men: Days of Future Past
X-Men: Days of Future Past
1877832
Hugh Jackman, James McAvoy, Michael Fassbender, Jennifer Lawrence
Hugh Jackman : Logan : Wolverine
Second_cast actor: James McAvoy : Charles Xavier
===end=====
{'Title': 'Spider-Man: Into the Spider-Verse', 'Year': '2018', 'Rated': 'PG', 'Released': '14 Dec 2018', 'Runtime': '117 min', 'Genre': 'Animation, Action, Adventure, Family, Sci-Fi', 'Director': 'Bob Persichetti, Peter Ramsey, Rodney Rothman', 'Writer': 'Phil Lord (screenplay by), Rodney Rothman (screenplay by), Phil Lord (story by)', 'Actors': 'Shameik Moore, Jake Johnson, Hailee Steinfeld, Mahershala Ali', 'Plot': 'Teen Miles Morales becomes the Spider-Man of his reality, and must join with five counterparts from other dimensions to stop a threat for all realities.', 'Language': 'English, Spanish', 'Country': 'USA', 'Awards': 'Won 1 Oscar. Another 79 wins & 55 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMjMwNDkxMTgzOF5BMl5BanBnXkFtZTgwNTkwNTQ3NjM@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '8.4/10'}, {'Source': 'Rotten Tomatoes', 'Value': '97%'}, {'Source': 'Metacritic', 'Value': '87/100'}], 'Metascore': '87', 'imdbRating': '8.4', 'imdbVotes': '325,905', 'imdbID': 'tt4633694', 'Type': 'movie', 'DVD': '26 Feb 2019', 'BoxOffice': 'N/A', 'Production': 'Sony Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
21
https://m.media-amazon.com/images/M/MV5BMjMwNDkxMTgzOF5BMl5BanBnXkFtZTgwNTkwNTQ3NjM@._V1_SX300.jpg
Movie title: Spider-Man: Into the Spider-Verse
Spider-Man: Into the Spider-Verse
4633694
Shameik Moore, Jake Johnson, Hailee Steinfeld, Mahershala Ali
Shameik Moore : Miles Morales : None
Second_cast actor: Jake Johnson : Peter B. Parker
===end=====
{'Title': 'Superman II', 'Year': '1980', 'Rated': 'PG', 'Released': '19 Jun 1981', 'Runtime': '127 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Richard Lester, Richard Donner', 'Writer': 'Jerry Siegel (character created by: Superman), Joe Shuster (character created by: Superman), Mario Puzo (story by), Mario Puzo (screenplay by), David Newman (screenplay by), Leslie Newman (screenplay by)', 'Actors': 'Gene Hackman, Christopher Reeve, Ned Beatty, Jackie Cooper', 'Plot': 'Superman agrees to sacrifice his powers to start a relationship with Lois Lane, unaware that three Kryptonian criminals he inadvertently released are conquering Earth.', 'Language': 'English, French, Russian', 'Country': 'USA, UK, Canada', 'Awards': '3 wins & 7 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMWUzNDJjMDUtNGEzMi00YThlLTlkMmEtNjVlOGQwOWM3MjM3XkEyXkFqcGdeQXVyMTMxODk2OTU@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '6.8/10'}, {'Source': 'Rotten Tomatoes', 'Value': '87%'}, {'Source': 'Metacritic', 'Value': '83/100'}], 'Metascore': '83', 'imdbRating': '6.8', 'imdbVotes': '95,592', 'imdbID': 'tt0081573', 'Type': 'movie', 'DVD': '01 May 2001', 'BoxOffice': 'N/A', 'Production': 'Warner Bros. Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
22
https://m.media-amazon.com/images/M/MV5BMWUzNDJjMDUtNGEzMi00YThlLTlkMmEtNjVlOGQwOWM3MjM3XkEyXkFqcGdeQXVyMTMxODk2OTU@._V1_SX300.jpg
Movie title: Superman II
Superman II
0081573
Gene Hackman, Christopher Reeve, Ned Beatty, Jackie Cooper
Gene Hackman : Lex Luthor : None
Second_cast actor: Christopher Reeve : Superman / Clark Kent
===end=====
{'Title': 'X2: X-Men United', 'Year': '2003', 'Rated': 'PG-13', 'Released': '02 May 2003', 'Runtime': '134 min', 'Genre': 'Action, Sci-Fi, Thriller', 'Director': 'Bryan Singer', 'Writer': 'Zak Penn (story), David Hayter (story), Bryan Singer (story), Michael Dougherty (screenplay), Dan Harris (screenplay), David Hayter (screenplay)', 'Actors': 'Patrick Stewart, Hugh Jackman, Ian McKellen, Halle Berry', 'Plot': 'When anti-mutant Colonel William Stryker kidnaps Professor X and attacks his school, the X-Men must ally with their archenemy Magneto to stop him.', 'Language': 'English, German, Italian, Spanish', 'Country': 'Canada, USA', 'Awards': '6 wins & 41 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDk0NjYxMzIzOF5BMl5BanBnXkFtZTYwMTc1MjU3._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.4/10'}, {'Source': 'Rotten Tomatoes', 'Value': '85%'}, {'Source': 'Metacritic', 'Value': '68/100'}], 'Metascore': '68', 'imdbRating': '7.4', 'imdbVotes': '501,725', 'imdbID': 'tt0290334', 'Type': 'movie', 'DVD': '25 Nov 2003', 'BoxOffice': '$214,813,155', 'Production': '20th Century Fox', 'Website': 'N/A', 'Response': 'True'}
=============
23
https://m.media-amazon.com/images/M/MV5BNDk0NjYxMzIzOF5BMl5BanBnXkFtZTYwMTc1MjU3._V1_SX300.jpg
Movie title: X2: X-Men United
X2: X-Men United
0290334
Patrick Stewart, Hugh Jackman, Ian McKellen, Halle Berry
Patrick Stewart : Professor Charles Xavier : None
Second_cast actor: Hugh Jackman : Logan / Wolverine
===end=====
{'Title': 'Iron Man 2', 'Year': '2010', 'Rated': 'PG-13', 'Released': '07 May 2010', 'Runtime': '124 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Jon Favreau', 'Writer': 'Justin Theroux (screenplay), Stan Lee (Marvel comic book), Don Heck (Marvel comic book), Larry Lieber (Marvel comic book), Jack Kirby (Marvel comic book)', 'Actors': 'Robert Downey Jr., Gwyneth Paltrow, Don Cheadle, Scarlett Johansson', 'Plot': "With the world now aware of his identity as Iron Man, Tony Stark must contend with both his declining health and a vengeful mad man with ties to his father's legacy.", 'Language': 'English, French, Russian', 'Country': 'USA', 'Awards': 'Nominated for 1 Oscar. Another 7 wins & 43 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTM0MDgwNjMyMl5BMl5BanBnXkFtZTcwNTg3NzAzMw@@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.0/10'}, {'Source': 'Rotten Tomatoes', 'Value': '73%'}, {'Source': 'Metacritic', 'Value': '57/100'}], 'Metascore': '57', 'imdbRating': '7.0', 'imdbVotes': '701,350', 'imdbID': 'tt1228705', 'Type': 'movie', 'DVD': '28 Sep 2010', 'BoxOffice': '$312,057,433', 'Production': 'Paramount Studios', 'Website': 'N/A', 'Response': 'True'}
=============
24
https://m.media-amazon.com/images/M/MV5BMTM0MDgwNjMyMl5BMl5BanBnXkFtZTcwNTg3NzAzMw@@._V1_SX300.jpg
Movie title: Iron Man 2
Iron Man 2
1228705
Robert Downey Jr., Gwyneth Paltrow, Don Cheadle, Scarlett Johansson
Robert Downey Jr. : Tony Stark : None
Second_cast actor: Gwyneth Paltrow : Pepper Potts
===end=====
{'Title': 'Deadpool 2', 'Year': '2018', 'Rated': 'R', 'Released': '18 May 2018', 'Runtime': '119 min', 'Genre': 'Action, Adventure, Comedy, Sci-Fi', 'Director': 'David Leitch', 'Writer': 'Rhett Reese, Paul Wernick, Ryan Reynolds', 'Actors': 'Ryan Reynolds, Josh Brolin, Morena Baccarin, Julian Dennison', 'Plot': 'Foul-mouthed mutant mercenary Wade Wilson (a.k.a. Deadpool), brings together a team of fellow mutant rogues to protect a young boy with supernatural abilities from the brutal, time-traveling cyborg Cable.', 'Language': 'English, Cantonese, Spanish, Russian', 'Country': 'USA', 'Awards': '6 wins & 50 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNjk1Njk3YjctMmMyYS00Y2I4LThhMzktN2U0MTMyZTFlYWQ5XkEyXkFqcGdeQXVyODM2ODEzMDA@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.7/10'}, {'Source': 'Rotten Tomatoes', 'Value': '84%'}, {'Source': 'Metacritic', 'Value': '66/100'}], 'Metascore': '66', 'imdbRating': '7.7', 'imdbVotes': '457,120', 'imdbID': 'tt5463162', 'Type': 'movie', 'DVD': '21 Aug 2018', 'BoxOffice': 'N/A', 'Production': '20th Century Fox', 'Website': 'N/A', 'Response': 'True'}
=============
25
https://m.media-amazon.com/images/M/MV5BNjk1Njk3YjctMmMyYS00Y2I4LThhMzktN2U0MTMyZTFlYWQ5XkEyXkFqcGdeQXVyODM2ODEzMDA@._V1_SX300.jpg
Movie title: Deadpool 2
Deadpool 2
5463162
Ryan Reynolds, Josh Brolin, Morena Baccarin, Julian Dennison
Ryan Reynolds : None : None
Second_cast actor: Josh Brolin : Cable
===end=====
{'Title': 'Logan', 'Year': '2017', 'Rated': 'R', 'Released': '03 Mar 2017', 'Runtime': '137 min', 'Genre': 'Action, Drama, Sci-Fi, Thriller', 'Director': 'James Mangold', 'Writer': 'James Mangold (story by), Scott Frank (screenplay by), James Mangold (screenplay by), Michael Green (screenplay by)', 'Actors': 'Hugh Jackman, Patrick Stewart, Dafne Keen, Boyd Holbrook', 'Plot': 'In a future where mutants are nearly extinct, an elderly and weary Logan leads a quiet life. But when Laura, a mutant child pursued by scientists, comes to him for help, he must get her to safety.', 'Language': 'English, Spanish', 'Country': 'USA', 'Awards': 'Nominated for 1 Oscar. Another 26 wins & 73 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYzc5MTU4N2EtYTkyMi00NjdhLTg3NWEtMTY4OTEyMzJhZTAzXkEyXkFqcGdeQXVyNjc1NTYyMjg@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '8.1/10'}, {'Source': 'Rotten Tomatoes', 'Value': '93%'}, {'Source': 'Metacritic', 'Value': '77/100'}], 'Metascore': '77', 'imdbRating': '8.1', 'imdbVotes': '623,423', 'imdbID': 'tt3315342', 'Type': 'movie', 'DVD': '23 May 2017', 'BoxOffice': '$226,276,809', 'Production': '20th Century Fox', 'Website': 'N/A', 'Response': 'True'}
=============
26
https://m.media-amazon.com/images/M/MV5BYzc5MTU4N2EtYTkyMi00NjdhLTg3NWEtMTY4OTEyMzJhZTAzXkEyXkFqcGdeQXVyNjc1NTYyMjg@._V1_SX300.jpg
Movie title: Logan
Logan
3315342
Hugh Jackman, Patrick Stewart, Dafne Keen, Boyd Holbrook
Hugh Jackman : Logan : X-24
Second_cast actor: Patrick Stewart : Charles
===end=====
{'Title': 'Captain Marvel', 'Year': '2019', 'Rated': 'PG-13', 'Released': '08 Mar 2019', 'Runtime': '123 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Anna Boden, Ryan Fleck', 'Writer': 'Anna Boden (screenplay by), Ryan Fleck (screenplay by), Geneva Robertson-Dworet (screenplay by), Nicole Perlman (story by), Meg LeFauve (story by), Anna Boden (story by), Ryan Fleck (story by), Geneva Robertson-Dworet (story by)', 'Actors': 'Brie Larson, Samuel L. Jackson, Ben Mendelsohn, Jude Law', 'Plot': "Carol Danvers becomes one of the universe's most powerful heroes when Earth is caught in the middle of a galactic war between two alien races.", 'Language': 'English', 'Country': 'USA, Australia', 'Awards': '7 wins & 46 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTE0YWFmOTMtYTU2ZS00ZTIxLWE3OTEtYTNiYzBkZjViZThiXkEyXkFqcGdeQXVyODMzMzQ4OTI@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '6.9/10'}, {'Source': 'Rotten Tomatoes', 'Value': '78%'}, {'Source': 'Metacritic', 'Value': '64/100'}], 'Metascore': '64', 'imdbRating': '6.9', 'imdbVotes': '419,105', 'imdbID': 'tt4154664', 'Type': 'movie', 'DVD': '11 Jun 2019', 'BoxOffice': 'N/A', 'Production': 'Marvel Studios', 'Website': 'N/A', 'Response': 'True'}
=============
27
https://m.media-amazon.com/images/M/MV5BMTE0YWFmOTMtYTU2ZS00ZTIxLWE3OTEtYTNiYzBkZjViZThiXkEyXkFqcGdeQXVyODMzMzQ4OTI@._V1_SX300.jpg
Movie title: Captain Marvel
Captain Marvel
4154664
Brie Larson, Samuel L. Jackson, Ben Mendelsohn, Jude Law
Brie Larson : None : None
Second_cast actor: Samuel L. Jackson : Nick Fury
===end=====
{'Title': 'Captain America: The Winter Soldier', 'Year': '2014', 'Rated': 'PG-13', 'Released': '04 Apr 2014', 'Runtime': '136 min', 'Genre': 'Action, Adventure, Sci-Fi, Thriller', 'Director': 'Anthony Russo, Joe Russo', 'Writer': 'Christopher Markus (screenplay by), Stephen McFeely (screenplay by), Joe Simon (based on the Marvel comics by), Jack Kirby (based on the Marvel comics by)', 'Actors': 'Chris Evans, Samuel L. Jackson, Scarlett Johansson, Robert Redford', 'Plot': 'As Steve Rogers struggles to embrace his role in the modern world, he teams up with a fellow Avenger and S.H.I.E.L.D agent, Black Widow, to battle a new threat from history: an assassin known as the Winter Soldier.', 'Language': 'English, French', 'Country': 'USA', 'Awards': 'Nominated for 1 Oscar. Another 5 wins & 50 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMzA2NDkwODAwM15BMl5BanBnXkFtZTgwODk5MTgzMTE@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.7/10'}, {'Source': 'Rotten Tomatoes', 'Value': '90%'}, {'Source': 'Metacritic', 'Value': '70/100'}], 'Metascore': '70', 'imdbRating': '7.7', 'imdbVotes': '714,280', 'imdbID': 'tt1843866', 'Type': 'movie', 'DVD': '09 Sep 2014', 'BoxOffice': '$228,636,083', 'Production': 'Walt Disney Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
28
https://m.media-amazon.com/images/M/MV5BMzA2NDkwODAwM15BMl5BanBnXkFtZTgwODk5MTgzMTE@._V1_SX300.jpg
Movie title: Captain America: The Winter Soldier
Captain America: The Winter Soldier
1843866
Chris Evans, Samuel L. Jackson, Scarlett Johansson, Robert Redford
Chris Evans : Steve Rogers : Captain America
Second_cast actor: Samuel L. Jackson : Nick Fury
===end=====
{'Title': 'Avengers: Age of Ultron', 'Year': '2015', 'Rated': 'PG-13', 'Released': '01 May 2015', 'Runtime': '141 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Joss Whedon', 'Writer': 'Joss Whedon, Stan Lee (based on the Marvel comics by), Jack Kirby (based on the Marvel comics by), Joe Simon (character created by: Captain America), Jack Kirby (character created by: Captain America), Jim Starlin (character created by: Thanos)', 'Actors': 'Robert Downey Jr., Chris Hemsworth, Mark Ruffalo, Chris Evans', 'Plot': "When Tony Stark and Bruce Banner try to jump-start a dormant peacekeeping program called Ultron, things go horribly wrong and it's up to Earth's mightiest heroes to stop the villainous Ultron from enacting his terrible plan.", 'Language': 'English, Korean', 'Country': 'USA', 'Awards': '8 wins & 47 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTM4OGJmNWMtOTM4Ni00NTE3LTg3MDItZmQxYjc4N2JhNmUxXkEyXkFqcGdeQXVyNTgzMDMzMTg@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.3/10'}, {'Source': 'Rotten Tomatoes', 'Value': '76%'}, {'Source': 'Metacritic', 'Value': '66/100'}], 'Metascore': '66', 'imdbRating': '7.3', 'imdbVotes': '717,864', 'imdbID': 'tt2395427', 'Type': 'movie', 'DVD': '02 Oct 2015', 'BoxOffice': '$429,113,729', 'Production': 'Walt Disney Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
29
https://m.media-amazon.com/images/M/MV5BMTM4OGJmNWMtOTM4Ni00NTE3LTg3MDItZmQxYjc4N2JhNmUxXkEyXkFqcGdeQXVyNTgzMDMzMTg@._V1_SX300.jpg
Movie title: Avengers: Age of Ultron
Avengers: Age of Ultron
2395427
Robert Downey Jr., Chris Hemsworth, Mark Ruffalo, Chris Evans
Robert Downey Jr. : Tony Stark : Iron Man
Second_cast actor: Chris Hemsworth : Thor
===end=====
{'Title': 'Thor: Ragnarok', 'Year': '2017', 'Rated': 'PG-13', 'Released': '03 Nov 2017', 'Runtime': '130 min', 'Genre': 'Action, Adventure, Comedy, Fantasy, Sci-Fi', 'Director': 'Taika Waititi', 'Writer': 'Eric Pearson, Craig Kyle, Christopher L. Yost, Stan Lee (based on the Marvel comics by), Larry Lieber (based on the Marvel comics by), Jack Kirby (based on the Marvel comics by)', 'Actors': 'Chris Hemsworth, Tom Hiddleston, Cate Blanchett, Idris Elba', 'Plot': 'Imprisoned on the planet Sakaar, Thor must race against time to return to Asgard and stop Ragnarök, the destruction of his world, at the hands of the powerful and ruthless villain Hela.', 'Language': 'English', 'Country': 'USA', 'Awards': '6 wins & 49 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMjMyNDkzMzI1OF5BMl5BanBnXkFtZTgwODcxODg5MjI@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.9/10'}, {'Source': 'Rotten Tomatoes', 'Value': '93%'}, {'Source': 'Metacritic', 'Value': '74/100'}], 'Metascore': '74', 'imdbRating': '7.9', 'imdbVotes': '559,830', 'imdbID': 'tt3501632', 'Type': 'movie', 'DVD': '06 Mar 2018', 'BoxOffice': '$314,971,245', 'Production': 'Walt Disney Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
30
https://m.media-amazon.com/images/M/MV5BMjMyNDkzMzI1OF5BMl5BanBnXkFtZTgwODcxODg5MjI@._V1_SX300.jpg
Movie title: Thor: Ragnarok
Thor: Ragnarok
3501632
Chris Hemsworth, Tom Hiddleston, Cate Blanchett, Idris Elba
Chris Hemsworth : Thor : None
Second_cast actor: Tom Hiddleston : Loki
===end=====
{'Title': 'Guardians of the Galaxy Vol. 2', 'Year': '2017', 'Rated': 'PG-13', 'Released': '05 May 2017', 'Runtime': '136 min', 'Genre': 'Action, Adventure, Comedy, Sci-Fi', 'Director': 'James Gunn', 'Writer': 'James Gunn, Dan Abnett (based on the Marvel comics by), Andy Lanning (based on the Marvel comics by), Steve Englehart (Star-Lord created by), Steve Gan (Star-Lord created by), Jim Starlin (Gamora and Drax created by), Stan Lee (Groot created by), Larry Lieber (Groot created by), Jack Kirby (Groot created by), Bill Mantlo (Rocket Raccoon created by), Keith Giffen (Rocket Raccoon created by), Steve Gerber (Howard the Duck created by), Val Mayerik (Howard the Duck created by)', 'Actors': 'Chris Pratt, Zoe Saldana, Dave Bautista, Vin Diesel', 'Plot': "The Guardians struggle to keep together as a team while dealing with their personal family issues, notably Star-Lord's encounter with his father the ambitious celestial being Ego.", 'Language': 'English', 'Country': 'USA', 'Awards': 'Nominated for 1 Oscar. Another 15 wins & 56 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNjM0NTc0NzItM2FlYS00YzEwLWE0YmUtNTA2ZWIzODc2OTgxXkEyXkFqcGdeQXVyNTgwNzIyNzg@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.6/10'}, {'Source': 'Rotten Tomatoes', 'Value': '85%'}, {'Source': 'Metacritic', 'Value': '67/100'}], 'Metascore': '67', 'imdbRating': '7.6', 'imdbVotes': '545,424', 'imdbID': 'tt3896198', 'Type': 'movie', 'DVD': '22 Aug 2017', 'BoxOffice': '$389,804,217', 'Production': 'Walt Disney Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
31
https://m.media-amazon.com/images/M/MV5BNjM0NTc0NzItM2FlYS00YzEwLWE0YmUtNTA2ZWIzODc2OTgxXkEyXkFqcGdeQXVyNTgwNzIyNzg@._V1_SX300.jpg
Movie title: Guardians of the Galaxy Vol. 2
Guardians of the Galaxy Vol. 2
3896198
Chris Pratt, Zoe Saldana, Dave Bautista, Vin Diesel
Chris Pratt : Peter Quill : Star-Lord
Second_cast actor: Zoe Saldana : Gamora
===end=====
{'Title': 'Batman', 'Year': '1989', 'Rated': 'PG-13', 'Released': '23 Jun 1989', 'Runtime': '126 min', 'Genre': 'Action, Adventure', 'Director': 'Tim Burton', 'Writer': 'Bob Kane (Batman characters), Sam Hamm (story), Sam Hamm (screenplay), Warren Skaaren (screenplay)', 'Actors': 'Michael Keaton, Jack Nicholson, Kim Basinger, Robert Wuhl', 'Plot': 'The Dark Knight of Gotham City begins his war on crime with his first major enemy being Jack Napier, a criminal who becomes the clownishly homicidal Joker.', 'Language': 'English, French, Spanish', 'Country': 'USA, UK', 'Awards': 'Won 1 Oscar. Another 8 wins & 26 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTYwNjAyODIyMF5BMl5BanBnXkFtZTYwNDMwMDk2._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.5/10'}, {'Source': 'Rotten Tomatoes', 'Value': '71%'}, {'Source': 'Metacritic', 'Value': '69/100'}], 'Metascore': '69', 'imdbRating': '7.5', 'imdbVotes': '330,823', 'imdbID': 'tt0096895', 'Type': 'movie', 'DVD': '25 Mar 1997', 'BoxOffice': 'N/A', 'Production': 'Warner Bros. Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
32
https://m.media-amazon.com/images/M/MV5BMTYwNjAyODIyMF5BMl5BanBnXkFtZTYwNDMwMDk2._V1_SX300.jpg
Movie title: Batman
Batman
0096895
Michael Keaton, Jack Nicholson, Kim Basinger, Robert Wuhl
Michael Keaton : Batman : Bruce Wayne
Second_cast actor: Jack Nicholson : Joker / Jack Napier
===end=====
{'Title': 'Deadpool', 'Year': '2016', 'Rated': 'R', 'Released': '12 Feb 2016', 'Runtime': '108 min', 'Genre': 'Action, Adventure, Comedy, Sci-Fi', 'Director': 'Tim Miller', 'Writer': 'Rhett Reese, Paul Wernick', 'Actors': 'Ryan Reynolds, Karan Soni, Ed Skrein, Michael Benyaer', 'Plot': 'A wisecracking mercenary gets experimented on and becomes immortal but ugly, and sets out to track down the man who ruined his looks.', 'Language': 'English', 'Country': 'USA', 'Awards': 'Nominated for 2 Golden Globes. Another 28 wins & 75 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYzE5MjY1ZDgtMTkyNC00MTMyLThhMjAtZGI5OTE1NzFlZGJjXkEyXkFqcGdeQXVyNjU0OTQ0OTY@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '8.0/10'}, {'Source': 'Rotten Tomatoes', 'Value': '85%'}, {'Source': 'Metacritic', 'Value': '65/100'}], 'Metascore': '65', 'imdbRating': '8.0', 'imdbVotes': '877,142', 'imdbID': 'tt1431045', 'Type': 'movie', 'DVD': '10 May 2016', 'BoxOffice': '$328,674,489', 'Production': '20th Century Fox', 'Website': 'N/A', 'Response': 'True'}
=============
33
https://m.media-amazon.com/images/M/MV5BYzE5MjY1ZDgtMTkyNC00MTMyLThhMjAtZGI5OTE1NzFlZGJjXkEyXkFqcGdeQXVyNjU0OTQ0OTY@._V1_SX300.jpg
Movie title: Deadpool
Deadpool
1431045
Ryan Reynolds, Karan Soni, Ed Skrein, Michael Benyaer
Ryan Reynolds : Wade : Deadpool
Second_cast actor: Karan Soni : Dopinder
===end=====
{'Title': 'Iron Man 3', 'Year': '2013', 'Rated': 'PG-13', 'Released': '03 May 2013', 'Runtime': '130 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Shane Black', 'Writer': 'Drew Pearce (screenplay by), Shane Black (screenplay by), Stan Lee (based on the Marvel comic book by), Don Heck (based on the Marvel comic book by), Larry Lieber (based on the Marvel comic book by), Jack Kirby (based on the Marvel comic book by), Warren Ellis (based on the "Extremis" mini-series written by), Adi Granov (based on the "Extremis" mini-series illustrated by)', 'Actors': 'Robert Downey Jr., Gwyneth Paltrow, Don Cheadle, Guy Pearce', 'Plot': "When Tony Stark's world is torn apart by a formidable terrorist called the Mandarin, he starts an odyssey of rebuilding and retribution.", 'Language': 'English', 'Country': 'USA', 'Awards': 'Nominated for 1 Oscar. Another 20 wins & 62 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMjE5MzcyNjk1M15BMl5BanBnXkFtZTcwMjQ4MjcxOQ@@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.2/10'}, {'Source': 'Rotten Tomatoes', 'Value': '79%'}, {'Source': 'Metacritic', 'Value': '62/100'}], 'Metascore': '62', 'imdbRating': '7.2', 'imdbVotes': '736,879', 'imdbID': 'tt1300854', 'Type': 'movie', 'DVD': '24 Sep 2013', 'BoxOffice': '$408,992,272', 'Production': 'Walt Disney Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
34
https://m.media-amazon.com/images/M/MV5BMjE5MzcyNjk1M15BMl5BanBnXkFtZTcwMjQ4MjcxOQ@@._V1_SX300.jpg
Movie title: Iron Man 3
Iron Man 3
1300854
Robert Downey Jr., Gwyneth Paltrow, Don Cheadle, Guy Pearce
Robert Downey Jr. : Tony Stark : None
Second_cast actor: Gwyneth Paltrow : Pepper Potts
===end=====
{'Title': 'Spider-Man: Far from Home', 'Year': '2019', 'Rated': 'PG-13', 'Released': '02 Jul 2019', 'Runtime': '129 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Jon Watts', 'Writer': 'Chris McKenna, Erik Sommers, Stan Lee (based on the Marvel comic book by), Steve Ditko (based on the Marvel comic book by)', 'Actors': 'Tom Holland, Samuel L. Jackson, Jake Gyllenhaal, Marisa Tomei', 'Plot': 'Following the events of Avengers: Endgame (2019), Spider-Man must step up to take on new threats in a world that has changed forever.', 'Language': 'English, Italian, Czech', 'Country': 'USA', 'Awards': '9 wins & 21 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMGZlNTY1ZWUtYTMzNC00ZjUyLWE0MjQtMTMxN2E3ODYxMWVmXkEyXkFqcGdeQXVyMDM2NDM2MQ@@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.5/10'}, {'Source': 'Rotten Tomatoes', 'Value': '90%'}, {'Source': 'Metacritic', 'Value': '69/100'}], 'Metascore': '69', 'imdbRating': '7.5', 'imdbVotes': '299,929', 'imdbID': 'tt6320628', 'Type': 'movie', 'DVD': '17 Sep 2019', 'BoxOffice': 'N/A', 'Production': 'Sony Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
35
https://m.media-amazon.com/images/M/MV5BMGZlNTY1ZWUtYTMzNC00ZjUyLWE0MjQtMTMxN2E3ODYxMWVmXkEyXkFqcGdeQXVyMDM2NDM2MQ@@._V1_SX300.jpg
Movie title: Spider-Man: Far from Home
Spider-Man: Far from Home
6320628
Tom Holland, Samuel L. Jackson, Jake Gyllenhaal, Marisa Tomei
Tom Holland : Peter Parker : Spider-Man
Second_cast actor: Samuel L. Jackson : Nick Fury
===end=====
{'Title': 'Spider-Man: Homecoming', 'Year': '2017', 'Rated': 'PG-13', 'Released': '07 Jul 2017', 'Runtime': '133 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Jon Watts', 'Writer': 'Jonathan Goldstein (screenplay by), John Francis Daley (screenplay by), Jon Watts (screenplay by), Christopher Ford (screenplay by), Chris McKenna (screenplay by), Erik Sommers (screenplay by), Jonathan Goldstein (screen story by), John Francis Daley (screen story by), Stan Lee (based on the Marvel comic book by), Steve Ditko (based on the Marvel comic book by), Joe Simon (Captain America created by), Jack Kirby (Captain America created by)', 'Actors': 'Tom Holland, Michael Keaton, Robert Downey Jr., Marisa Tomei', 'Plot': 'Peter Parker balances his life as an ordinary high school student in Queens with his superhero alter-ego Spider-Man, and finds himself on the trail of a new menace prowling the skies of New York City.', 'Language': 'English, Spanish', 'Country': 'USA', 'Awards': '7 wins & 9 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNTk4ODQ1MzgzNl5BMl5BanBnXkFtZTgwMTMyMzM4MTI@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.4/10'}, {'Source': 'Rotten Tomatoes', 'Value': '92%'}, {'Source': 'Metacritic', 'Value': '73/100'}], 'Metascore': '73', 'imdbRating': '7.4', 'imdbVotes': '490,635', 'imdbID': 'tt2250912', 'Type': 'movie', 'DVD': '17 Oct 2017', 'BoxOffice': '$334,166,825', 'Production': 'Sony Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
36
https://m.media-amazon.com/images/M/MV5BNTk4ODQ1MzgzNl5BMl5BanBnXkFtZTgwMTMyMzM4MTI@._V1_SX300.jpg
Movie title: Spider-Man: Homecoming
Spider-Man: Homecoming
2250912
Tom Holland, Michael Keaton, Robert Downey Jr., Marisa Tomei
Tom Holland : Peter Parker : Spider-Man
Second_cast actor: Michael Keaton : Adrian Toomes / Vulture
===end=====
{'Title': 'Guardians of the Galaxy', 'Year': '2014', 'Rated': 'PG-13', 'Released': '01 Aug 2014', 'Runtime': '121 min', 'Genre': 'Action, Adventure, Comedy, Sci-Fi', 'Director': 'James Gunn', 'Writer': 'James Gunn, Nicole Perlman, Dan Abnett (based on the Marvel comics by), Andy Lanning (based on the Marvel comics by), Bill Mantlo (character created by: Rocket Raccoon), Keith Giffen (character created by: Rocket Raccoon), Jim Starlin (characters created by: Drax the Destroyer,  Gamora & Thanos), Steve Englehart (character created by: Star-Lord), Steve Gan (character created by: Star-Lord), Steve Gerber (character created by: Howard the Duck), Val Mayerik (character created by: Howard the Duck)', 'Actors': 'Chris Pratt, Zoe Saldana, Dave Bautista, Vin Diesel', 'Plot': 'A group of intergalactic criminals must pull together to stop a fanatical warrior with plans to purge the universe.', 'Language': 'English', 'Country': 'USA', 'Awards': 'Nominated for 2 Oscars. Another 52 wins & 100 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTAwMjU5OTgxNjZeQTJeQWpwZ15BbWU4MDUxNDYxODEx._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '8.0/10'}, {'Source': 'Rotten Tomatoes', 'Value': '91%'}, {'Source': 'Metacritic', 'Value': '76/100'}], 'Metascore': '76', 'imdbRating': '8.0', 'imdbVotes': '1,017,405', 'imdbID': 'tt2015381', 'Type': 'movie', 'DVD': '09 Dec 2014', 'BoxOffice': '$270,592,504', 'Production': 'Walt Disney Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
37
https://m.media-amazon.com/images/M/MV5BMTAwMjU5OTgxNjZeQTJeQWpwZ15BbWU4MDUxNDYxODEx._V1_SX300.jpg
Movie title: Guardians of the Galaxy
Guardians of the Galaxy
2015381
Chris Pratt, Zoe Saldana, Dave Bautista, Vin Diesel
Chris Pratt : Peter Quill : None
Second_cast actor: Zoe Saldana : Gamora
===end=====
{'Title': 'The Dark Knight Rises', 'Year': '2012', 'Rated': 'PG-13', 'Released': '20 Jul 2012', 'Runtime': '164 min', 'Genre': 'Action, Adventure', 'Director': 'Christopher Nolan', 'Writer': 'Jonathan Nolan (screenplay), Christopher Nolan (screenplay), Christopher Nolan (story), David S. Goyer (story), Bob Kane (characters)', 'Actors': 'Christian Bale, Gary Oldman, Tom Hardy, Joseph Gordon-Levitt', 'Plot': "Eight years after the Joker's reign of anarchy, Batman, with the help of the enigmatic Catwoman, is forced from his exile to save Gotham City from the brutal guerrilla terrorist Bane.", 'Language': 'English, Arabic', 'Country': 'UK, USA', 'Awards': 'Nominated for 1 BAFTA Film Award. Another 38 wins & 101 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTk4ODQzNDY3Ml5BMl5BanBnXkFtZTcwODA0NTM4Nw@@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '8.4/10'}, {'Source': 'Rotten Tomatoes', 'Value': '87%'}, {'Source': 'Metacritic', 'Value': '78/100'}], 'Metascore': '78', 'imdbRating': '8.4', 'imdbVotes': '1,473,295', 'imdbID': 'tt1345836', 'Type': 'movie', 'DVD': '03 Dec 2012', 'BoxOffice': '$448,130,642', 'Production': 'Warner Bros. Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
38
https://m.media-amazon.com/images/M/MV5BMTk4ODQzNDY3Ml5BMl5BanBnXkFtZTcwODA0NTM4Nw@@._V1_SX300.jpg
Movie title: The Dark Knight Rises
The Dark Knight Rises
1345836
Christian Bale, Gary Oldman, Tom Hardy, Joseph Gordon-Levitt
Christian Bale : Bruce Wayne : None
Second_cast actor: Gary Oldman : Commissioner Gordon
===end=====
{'Title': 'Captain America: Civil War', 'Year': '2016', 'Rated': 'PG-13', 'Released': '06 May 2016', 'Runtime': '147 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Anthony Russo, Joe Russo', 'Writer': 'Christopher Markus (screenplay by), Stephen McFeely (screenplay by), Joe Simon (based on the Marvel comics by), Jack Kirby (based on the Marvel comics by)', 'Actors': 'Chris Evans, Robert Downey Jr., Scarlett Johansson, Sebastian Stan', 'Plot': "Political involvement in the Avengers' affairs causes a rift between Captain America and Iron Man.", 'Language': 'English, German, Xhosa, Russian, Romanian, Hindi', 'Country': 'USA', 'Awards': '16 wins & 68 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMjQ0MTgyNjAxMV5BMl5BanBnXkFtZTgwNjUzMDkyODE@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.8/10'}, {'Source': 'Rotten Tomatoes', 'Value': '91%'}, {'Source': 'Metacritic', 'Value': '75/100'}], 'Metascore': '75', 'imdbRating': '7.8', 'imdbVotes': '640,554', 'imdbID': 'tt3498820', 'Type': 'movie', 'DVD': '13 Sep 2016', 'BoxOffice': '$408,080,554', 'Production': 'Walt Disney Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
39
https://m.media-amazon.com/images/M/MV5BMjQ0MTgyNjAxMV5BMl5BanBnXkFtZTgwNjUzMDkyODE@._V1_SX300.jpg
Movie title: Captain America: Civil War
Captain America: Civil War
3498820
Chris Evans, Robert Downey Jr., Scarlett Johansson, Sebastian Stan
Chris Evans : Steve Rogers : Captain America
Second_cast actor: Robert Downey Jr. : Tony Stark / Iron Man
===end=====
{'Title': 'Iron Man', 'Year': '2008', 'Rated': 'PG-13', 'Released': '02 May 2008', 'Runtime': '126 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Jon Favreau', 'Writer': 'Mark Fergus (screenplay), Hawk Ostby (screenplay), Art Marcum (screenplay), Matt Holloway (screenplay), Stan Lee (characters), Don Heck (characters), Larry Lieber (characters), Jack Kirby (characters)', 'Actors': 'Robert Downey Jr., Terrence Howard, Jeff Bridges, Gwyneth Paltrow', 'Plot': 'After being held captive in an Afghan cave, billionaire engineer Tony Stark creates a unique weaponized suit of armor to fight evil.', 'Language': 'Hungarian, Kurdish, Hindi, English, Persian, Urdu, Arabic', 'Country': 'USA, Canada', 'Awards': 'Nominated for 2 Oscars. Another 21 wins & 65 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTczNTI2ODUwOF5BMl5BanBnXkFtZTcwMTU0NTIzMw@@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.9/10'}, {'Source': 'Rotten Tomatoes', 'Value': '94%'}, {'Source': 'Metacritic', 'Value': '79/100'}], 'Metascore': '79', 'imdbRating': '7.9', 'imdbVotes': '917,253', 'imdbID': 'tt0371746', 'Type': 'movie', 'DVD': '30 Sep 2008', 'BoxOffice': '$318,298,180', 'Production': 'Paramount Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
40
https://m.media-amazon.com/images/M/MV5BMTczNTI2ODUwOF5BMl5BanBnXkFtZTcwMTU0NTIzMw@@._V1_SX300.jpg
Movie title: Iron Man
Iron Man
0371746
Robert Downey Jr., Terrence Howard, Jeff Bridges, Gwyneth Paltrow
Robert Downey Jr. : Tony Stark : None
Second_cast actor: Terrence Howard : Rhodey
===end=====
{'Title': 'Avengers: Infinity War', 'Year': '2018', 'Rated': 'PG-13', 'Released': '27 Apr 2018', 'Runtime': '149 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Anthony Russo, Joe Russo', 'Writer': 'Christopher Markus (screenplay by), Stephen McFeely (screenplay by), Stan Lee (based on the Marvel comics by), Jack Kirby (based on the Marvel comics by), Joe Simon (Captain America created by), Jack Kirby (Captain America created by), Steve Englehart (Star-Lord created by), Steve Gan (Star-Lord created by), Bill Mantlo (Rocket Raccoon created by), Keith Giffen (Rocket Raccoon created by), Jim Starlin (Thanos,  Gamora and Drax created by), Stan Lee (Groot created by), Larry Lieber (Groot created by), Jack Kirby (Groot created by), Steve Englehart (Mantis created by), Don Heck (Mantis created by)', 'Actors': 'Robert Downey Jr., Chris Hemsworth, Mark Ruffalo, Chris Evans', 'Plot': 'The Avengers and their allies must be willing to sacrifice all in an attempt to defeat the powerful Thanos before his blitz of devastation and ruin puts an end to the universe.', 'Language': 'English', 'Country': 'USA', 'Awards': 'Nominated for 1 Oscar. Another 46 wins & 73 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMjMxNjY2MDU1OV5BMl5BanBnXkFtZTgwNzY1MTUwNTM@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '8.4/10'}, {'Source': 'Rotten Tomatoes', 'Value': '85%'}, {'Source': 'Metacritic', 'Value': '68/100'}], 'Metascore': '68', 'imdbRating': '8.4', 'imdbVotes': '784,180', 'imdbID': 'tt4154756', 'Type': 'movie', 'DVD': '14 Aug 2018', 'BoxOffice': '$664,987,816', 'Production': 'Walt Disney Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
41
https://m.media-amazon.com/images/M/MV5BMjMxNjY2MDU1OV5BMl5BanBnXkFtZTgwNzY1MTUwNTM@._V1_SX300.jpg
Movie title: Avengers: Infinity War
Avengers: Infinity War
4154756
Robert Downey Jr., Chris Hemsworth, Mark Ruffalo, Chris Evans
Robert Downey Jr. : Tony Stark : Iron Man
Second_cast actor: Chris Hemsworth : Thor
===end=====
{'Title': 'Wonder Woman', 'Year': '2017', 'Rated': 'PG-13', 'Released': '02 Jun 2017', 'Runtime': '141 min', 'Genre': 'Action, Adventure, Fantasy, Sci-Fi, War', 'Director': 'Patty Jenkins', 'Writer': 'Allan Heinberg (screenplay by), Zack Snyder (story by), Allan Heinberg (story by), Jason Fuchs (story by), William Moulton Marston (Wonder Woman created by)', 'Actors': 'Gal Gadot, Chris Pine, Connie Nielsen, Robin Wright', 'Plot': 'When a pilot crashes and tells of conflict in the outside world, Diana, an Amazonian warrior in training, leaves home to fight a war, discovering her full powers and true destiny.', 'Language': 'English, German, Dutch, French, Spanish, Chinese, Greek,  Ancient (to 1453), North American Indian', 'Country': 'USA, China, Hong Kong', 'Awards': '24 wins & 70 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDFmZjgyMTEtYTk5MC00NmY0LWJhZjktOWY2MzI5YjkzODNlXkEyXkFqcGdeQXVyMDA4NzMyOA@@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.4/10'}, {'Source': 'Rotten Tomatoes', 'Value': '93%'}, {'Source': 'Metacritic', 'Value': '76/100'}], 'Metascore': '76', 'imdbRating': '7.4', 'imdbVotes': '531,221', 'imdbID': 'tt0451279', 'Type': 'movie', 'DVD': '19 Sep 2017', 'BoxOffice': '$412,400,625', 'Production': 'Warner Bros. Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
42
https://m.media-amazon.com/images/M/MV5BNDFmZjgyMTEtYTk5MC00NmY0LWJhZjktOWY2MzI5YjkzODNlXkEyXkFqcGdeQXVyMDA4NzMyOA@@._V1_SX300.jpg
Movie title: Wonder Woman
Wonder Woman
0451279
Gal Gadot, Chris Pine, Connie Nielsen, Robin Wright
Gal Gadot : Diana : None
Second_cast actor: Chris Pine : Steve Trevor
===end=====
{'Title': 'Spider-Man 2', 'Year': '2004', 'Rated': 'PG-13', 'Released': '30 Jun 2004', 'Runtime': '127 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Sam Raimi', 'Writer': 'Stan Lee (comic book), Steve Ditko (comic book), Alfred Gough (screen story), Miles Millar (screen story), Michael Chabon (screen story), Alvin Sargent (screenplay)', 'Actors': 'Tobey Maguire, Kirsten Dunst, James Franco, Alfred Molina', 'Plot': 'Peter Parker is beset with troubles in his failing personal life as he battles a brilliant scientist named Doctor Otto Octavius.', 'Language': 'English, Russian, Chinese', 'Country': 'USA', 'Awards': 'Won 1 Oscar. Another 24 wins & 60 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMzY2ODk4NmUtOTVmNi00ZTdkLTlmOWYtMmE2OWVhNTU2OTVkXkEyXkFqcGdeQXVyMTQxNzMzNDI@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.3/10'}, {'Source': 'Rotten Tomatoes', 'Value': '93%'}, {'Source': 'Metacritic', 'Value': '83/100'}], 'Metascore': '83', 'imdbRating': '7.3', 'imdbVotes': '529,344', 'imdbID': 'tt0316654', 'Type': 'movie', 'DVD': '30 Nov 2004', 'BoxOffice': '$373,377,893', 'Production': 'Sony Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
43
https://m.media-amazon.com/images/M/MV5BMzY2ODk4NmUtOTVmNi00ZTdkLTlmOWYtMmE2OWVhNTU2OTVkXkEyXkFqcGdeQXVyMTQxNzMzNDI@._V1_SX300.jpg
Movie title: Spider-Man 2
Spider-Man 2
0316654
Tobey Maguire, Kirsten Dunst, James Franco, Alfred Molina
Tobey Maguire : Spider-Man : Peter Parker
Second_cast actor: Kirsten Dunst : Mary Jane Watson
===end=====
{'Title': 'Spider-Man', 'Year': '2002', 'Rated': 'PG-13', 'Released': '03 May 2002', 'Runtime': '121 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Sam Raimi', 'Writer': 'Stan Lee (Marvel comic book), Steve Ditko (Marvel comic book), David Koepp (screenplay)', 'Actors': 'Tobey Maguire, Willem Dafoe, Kirsten Dunst, James Franco', 'Plot': 'When bitten by a genetically modified spider, a nerdy, shy, and awkward high school student gains spider-like abilities that he eventually must use to fight evil as a superhero after tragedy befalls his family.', 'Language': 'English', 'Country': 'USA', 'Awards': 'Nominated for 2 Oscars. Another 16 wins & 61 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BZDEyN2NhMjgtMjdhNi00MmNlLWE5YTgtZGE4MzNjMTRlMGEwXkEyXkFqcGdeQXVyNDUyOTg3Njg@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.3/10'}, {'Source': 'Rotten Tomatoes', 'Value': '90%'}, {'Source': 'Metacritic', 'Value': '73/100'}], 'Metascore': '73', 'imdbRating': '7.3', 'imdbVotes': '671,651', 'imdbID': 'tt0145487', 'Type': 'movie', 'DVD': '01 Nov 2002', 'BoxOffice': '$403,706,375', 'Production': 'Columbia Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
44
https://m.media-amazon.com/images/M/MV5BZDEyN2NhMjgtMjdhNi00MmNlLWE5YTgtZGE4MzNjMTRlMGEwXkEyXkFqcGdeQXVyNDUyOTg3Njg@._V1_SX300.jpg
Movie title: Spider-Man
Spider-Man
0145487
Tobey Maguire, Willem Dafoe, Kirsten Dunst, James Franco
Tobey Maguire : Spider-Man : Peter Parker
Second_cast actor: Willem Dafoe : Green Goblin / Norman Osborn
===end=====
{'Title': 'Superman', 'Year': '1978', 'Rated': 'PG', 'Released': '15 Dec 1978', 'Runtime': '143 min', 'Genre': 'Action, Adventure, Drama, Sci-Fi', 'Director': 'Richard Donner', 'Writer': 'Jerry Siegel (character created by: Superman), Joe Shuster (character created by: Superman), Mario Puzo (story), Mario Puzo (screenplay), David Newman (screenplay), Leslie Newman (screenplay), Robert Benton (screenplay)', 'Actors': 'Marlon Brando, Gene Hackman, Christopher Reeve, Ned Beatty', 'Plot': "An alien orphan is sent from his dying planet to Earth, where he grows up to become his adoptive home's first and greatest superhero.", 'Language': 'English', 'Country': 'USA, UK, Canada, Switzerland', 'Awards': 'Nominated for 3 Oscars. Another 17 wins & 19 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMzA0YWMwMTUtMTVhNC00NjRkLWE2ZTgtOWEzNjJhYzNiMTlkXkEyXkFqcGdeQXVyNjc1NTYyMjg@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.3/10'}, {'Source': 'Rotten Tomatoes', 'Value': '94%'}, {'Source': 'Metacritic', 'Value': '80/100'}], 'Metascore': '80', 'imdbRating': '7.3', 'imdbVotes': '155,025', 'imdbID': 'tt0078346', 'Type': 'movie', 'DVD': '01 May 2001', 'BoxOffice': 'N/A', 'Production': 'Warner Bros. Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
45
https://m.media-amazon.com/images/M/MV5BMzA0YWMwMTUtMTVhNC00NjRkLWE2ZTgtOWEzNjJhYzNiMTlkXkEyXkFqcGdeQXVyNjc1NTYyMjg@._V1_SX300.jpg
Movie title: Superman
Superman
0078346
Marlon Brando, Gene Hackman, Christopher Reeve, Ned Beatty
Marlon Brando : Jor-El : None
Second_cast actor: Gene Hackman : Lex Luthor
===end=====
{'Title': 'The Avengers', 'Year': '2012', 'Rated': 'PG-13', 'Released': '04 May 2012', 'Runtime': '143 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Joss Whedon', 'Writer': 'Joss Whedon (screenplay), Zak Penn (story), Joss Whedon (story)', 'Actors': 'Robert Downey Jr., Chris Evans, Mark Ruffalo, Chris Hemsworth', 'Plot': "Earth's mightiest heroes must come together and learn to fight as a team if they are going to stop the mischievous Loki and his alien army from enslaving humanity.", 'Language': 'English, Russian, Hindi', 'Country': 'USA', 'Awards': 'Nominated for 1 Oscar. Another 38 wins & 79 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDYxNjQyMjAtNTdiOS00NGYwLWFmNTAtNThmYjU5ZGI2YTI1XkEyXkFqcGdeQXVyMTMxODk2OTU@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '8.0/10'}, {'Source': 'Rotten Tomatoes', 'Value': '92%'}, {'Source': 'Metacritic', 'Value': '69/100'}], 'Metascore': '69', 'imdbRating': '8.0', 'imdbVotes': '1,234,641', 'imdbID': 'tt0848228', 'Type': 'movie', 'DVD': '25 Sep 2012', 'BoxOffice': '$623,279,547', 'Production': 'Walt Disney Pictures', 'Website': 'N/A', 'Response': 'True'}
=============
46
https://m.media-amazon.com/images/M/MV5BNDYxNjQyMjAtNTdiOS00NGYwLWFmNTAtNThmYjU5ZGI2YTI1XkEyXkFqcGdeQXVyMTMxODk2OTU@._V1_SX300.jpg
Movie title: The Avengers
The Avengers
0848228
Robert Downey Jr., Chris Evans, Mark Ruffalo, Chris Hemsworth
Robert Downey Jr. : Tony Stark : Iron Man
Second_cast actor: Chris Evans : Steve Rogers / Captain America
===end=====
{'Title': 'Avengers: Endgame', 'Year': '2019', 'Rated': 'PG-13', 'Released': '26 Apr 2019', 'Runtime': '181 min', 'Genre': 'Action, Adventure, Drama, Sci-Fi', 'Director': 'Anthony Russo, Joe Russo', 'Writer': 'Christopher Markus (screenplay by), Stephen McFeely (screenplay by), Stan Lee (based on the Marvel comics by), Jack Kirby (based on the Marvel comics by), Joe Simon (Captain America created by), Jack Kirby (Captain America created by), Steve Englehart (Star-Lord created by), Steve Gan (Star-Lord created by), Bill Mantlo (Rocket Raccoon created by), Keith Giffen (Rocket Raccoon created by), Jim Starlin (Thanos,  Gamora & Drax created by), Stan Lee (Groot created by), Larry Lieber (Groot created by), Jack Kirby (Groot created by), Steve Englehart (Mantis created by), Don Heck (Mantis created by)', 'Actors': 'Robert Downey Jr., Chris Evans, Mark Ruffalo, Chris Hemsworth', 'Plot': "After the devastating events of Avengers: Infinity War (2018), the universe is in ruins. With the help of remaining allies, the Avengers assemble once more in order to reverse Thanos' actions and restore balance to the universe.", 'Language': 'English, Japanese, Xhosa, German', 'Country': 'USA', 'Awards': 'Nominated for 1 Oscar. Another 65 wins & 103 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTc5MDE2ODcwNV5BMl5BanBnXkFtZTgwMzI2NzQ2NzM@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '8.4/10'}, {'Source': 'Rotten Tomatoes', 'Value': '94%'}, {'Source': 'Metacritic', 'Value': '78/100'}], 'Metascore': '78', 'imdbRating': '8.4', 'imdbVotes': '742,118', 'imdbID': 'tt4154796', 'Type': 'movie', 'DVD': '30 Jul 2019', 'BoxOffice': 'N/A', 'Production': 'Marvel Studios', 'Website': 'N/A', 'Response': 'True'}
=============
47
https://m.media-amazon.com/images/M/MV5BMTc5MDE2ODcwNV5BMl5BanBnXkFtZTgwMzI2NzQ2NzM@._V1_SX300.jpg
Movie title: Avengers: Endgame
Avengers: Endgame
4154796
Robert Downey Jr., Chris Evans, Mark Ruffalo, Chris Hemsworth
Robert Downey Jr. : Tony Stark : Iron Man
Second_cast actor: Chris Evans : Steve Rogers / Captain America
===end=====
{'Title': 'Black Panther', 'Year': '2018', 'Rated': 'PG-13', 'Released': '16 Feb 2018', 'Runtime': '134 min', 'Genre': 'Action, Adventure, Sci-Fi', 'Director': 'Ryan Coogler', 'Writer': 'Ryan Coogler, Joe Robert Cole, Stan Lee (based on the Marvel comics by), Jack Kirby (based on the Marvel Comics by)', 'Actors': "Chadwick Boseman, Michael B. Jordan, Lupita Nyong'o, Danai Gurira", 'Plot': "T'Challa, heir to the hidden but advanced kingdom of Wakanda, must step forward to lead his people into a new future and must confront a challenger from his country's past.", 'Language': 'English, Swahili, Nama, Xhosa, Korean', 'Country': 'USA', 'Awards': 'Won 3 Oscars. Another 109 wins & 265 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTg1MTY2MjYzNV5BMl5BanBnXkFtZTgwMTc4NTMwNDI@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '7.3/10'}, {'Source': 'Rotten Tomatoes', 'Value': '97%'}, {'Source': 'Metacritic', 'Value': '88/100'}], 'Metascore': '88', 'imdbRating': '7.3', 'imdbVotes': '587,388', 'imdbID': 'tt1825683', 'Type': 'movie', 'DVD': '15 May 2018', 'BoxOffice': '$501,105,037', 'Production': 'Marvel Studios', 'Website': 'N/A', 'Response': 'True'}
=============
48
https://m.media-amazon.com/images/M/MV5BMTg1MTY2MjYzNV5BMl5BanBnXkFtZTgwMTc4NTMwNDI@._V1_SX300.jpg
Movie title: Black Panther
Black Panther
1825683
Chadwick Boseman, Michael B. Jordan, Lupita Nyong'o, Danai Gurira
Chadwick Boseman : T'Challa : Black Panther
Second_cast actor: Michael B. Jordan : Erik Killmonger
===end=====
{'Title': 'The Dark Knight', 'Year': '2008', 'Rated': 'PG-13', 'Released': '18 Jul 2008', 'Runtime': '152 min', 'Genre': 'Action, Crime, Drama, Thriller', 'Director': 'Christopher Nolan', 'Writer': 'Jonathan Nolan (screenplay), Christopher Nolan (screenplay), Christopher Nolan (story), David S. Goyer (story), Bob Kane (characters)', 'Actors': 'Christian Bale, Heath Ledger, Aaron Eckhart, Michael Caine', 'Plot': 'When the menace known as the Joker wreaks havoc and chaos on the people of Gotham, Batman must accept one of the greatest psychological and physical tests of his ability to fight injustice.', 'Language': 'English, Mandarin', 'Country': 'USA, UK', 'Awards': 'Won 2 Oscars. Another 153 wins & 159 nominations.', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTMxNTMwODM0NF5BMl5BanBnXkFtZTcwODAyMTk2Mw@@._V1_SX300.jpg', 'Ratings': [{'Source': 'Internet Movie Database', 'Value': '9.0/10'}, {'Source': 'Rotten Tomatoes', 'Value': '94%'}, {'Source': 'Metacritic', 'Value': '84/100'}], 'Metascore': '84', 'imdbRating': '9.0', 'imdbVotes': '2,223,970', 'imdbID': 'tt0468569', 'Type': 'movie', 'DVD': '09 Dec 2008', 'BoxOffice': '$533,316,061', 'Production': 'Warner Bros. Pictures/Legendary', 'Website': 'N/A', 'Response': 'True'}
=============
49
https://m.media-amazon.com/images/M/MV5BMTMxNTMwODM0NF5BMl5BanBnXkFtZTcwODAyMTk2Mw@@._V1_SX300.jpg
Movie title: The Dark Knight
The Dark Knight
0468569
Christian Bale, Heath Ledger, Aaron Eckhart, Michael Caine
Christian Bale : Bruce Wayne : None
Second_cast actor: Heath Ledger : Joker
===end=====
In [34]:
# Creating a dict to hold an info
about_movie_dict = {
        'imdbID':imdbID,
        'id_clean': id_clean,
        'Title': Title,
        'Actor': Actor,
        'Role1': Role1,
        'Role2': Role2,
        'Year': Year,
        'Production': Production,
        'Plot': Plot,
        'Poster': Poster
}

print(len(about_movie_dict['Title']))
50
In [35]:
# Creating a data frame about_movie_df
about_movie_df = pd.DataFrame(about_movie_dict)
print(about_movie_df.count())
# Saving data to csv file
about_movie_df.to_csv('about_movie.csv', index=False)
about_movie_df.head()
imdbID        50
id_clean      50
Title         50
Actor         50
Role1         50
Role2         50
Year          50
Production    50
Plot          50
Poster        50
dtype: int64
Out[35]:
imdbID id_clean Title Actor Role1 Role2 Year Production Plot Poster
0 tt0109506 0109506 The Crow Brandon Lee Eric None 1994 LionsGate Entertainment A man brutally murdered comes back to life as ... https://m.media-amazon.com/images/M/MV5BM2Y4ZG...
1 tt0112462 0112462 Batman Forever Val Kilmer Batman Bruce Wayne 1995 Warner Bros. Pictures Batman must battle former district attorney Ha... https://m.media-amazon.com/images/M/MV5BNDdjYm...
2 tt0411477 0411477 Hellboy II: The Golden Army Ron Perlman Hellboy None 2008 Universal Pictures The mythical world starts a rebellion against ... https://m.media-amazon.com/images/M/MV5BMjA5Nz...
3 tt1981115 1981115 Thor: The Dark World Chris Hemsworth Thor None 2013 Walt Disney Pictures When the Dark Elves attempt to plunge the univ... https://m.media-amazon.com/images/M/MV5BMTQyNz...
4 tt0770828 0770828 Man of Steel Henry Cavill Clark Kent Kal-El 2013 Warner Bros. Pictures An alien child is evacuated from his dying wor... https://m.media-amazon.com/images/M/MV5BMTk5OD...
In [36]:
# Data cleaning, checking Role1 and Role2 columns, some of the rows have Hero name and Hero full name mixed.
# Checking that all Heroes names in Role1 and Heroes full name in the Role2, if they have one.
about_movie_df.loc[about_movie_df['Role1'] == 'Bruce Wayne', 'Role1'] = 'Batman'
about_movie_df.loc[about_movie_df['Role1'] == 'Batman','Role2'] = 'Bruce Wayne'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Hellboy', 'Role1'] = 'Hellboy'
about_movie_df.loc[about_movie_df['Role1'] == 'Hellboy','Role2'] = 'Anung Un Rama'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Tony Stark', 'Role1'] = 'Iron Man'
about_movie_df.loc[about_movie_df['Role1'] == 'Iron Man','Role2'] = 'Tony Stark'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Eric', 'Role1'] = 'Crow'
about_movie_df.loc[about_movie_df['Role1'] == 'Crow','Role2'] = 'Eric Draven'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Clark Kent', 'Role1'] = 'Superman'
about_movie_df.loc[about_movie_df['Role1'] == 'Superman','Role2'] = 'Clark Kent'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Thor', 'Role1'] = 'Thor'
about_movie_df.loc[about_movie_df['Role1'] == 'Thor','Role2'] = 'Thor Odinson'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Shazam', 'Role1'] = 'Captain Marvel'
about_movie_df.loc[about_movie_df['Title'] == 'Shazam!','Role2'] = 'Billy Batson'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Logan', 'Role1'] = 'Wolverine'
about_movie_df.loc[about_movie_df['Role1'] == 'Wolverine','Role2'] = 'Logan'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Scott Lang', 'Role1'] = 'Ant-Man'
about_movie_df.loc[about_movie_df['Role1'] == 'Ant-Man','Role2'] = 'Hank Pym'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Charles Xavier', 'Role1'] = 'Professor X'
about_movie_df.loc[about_movie_df['Role1'] == 'Professor X','Role2'] = 'Charles Francis Xavier'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Arthur', 'Role1'] = 'Aquaman'
about_movie_df.loc[about_movie_df['Role1'] == 'Aquaman','Role2'] = 'Orin'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Dr. Stephen Strange', 'Role1'] = 'Doctor Strange'
about_movie_df.loc[about_movie_df['Role1'] == 'Doctor Strange','Role2'] = 'Stephen Strange'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Miles Morales', 'Role1'] = 'Spider-Man'
about_movie_df.loc[about_movie_df['Role1'] == 'Spider-Man','Role2'] = 'Peter Parker'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Lex Luthor', 'Role1'] = 'Lex Luthor'
about_movie_df.loc[about_movie_df['Role1'] == 'Lex Luthor','Role2'] = 'Lex Luthor'
about_movie_df


about_movie_df.loc[about_movie_df['Role1'] == 'Professor Charles Xavier', 'Role1'] = 'Professor X'
about_movie_df.loc[about_movie_df['Role1'] == 'Professor X','Role2'] = 'Charles Francis Xavier'
about_movie_df

about_movie_df.loc[about_movie_df['Actor'] == 'Ryan Reynolds', 'Role1'] = 'Juggernaut'
about_movie_df.loc[about_movie_df['Role1'] == 'Juggernaut','Role2'] = 'Cain Marko'
about_movie_df

about_movie_df.loc[about_movie_df['Actor'] == 'Brie Larson', 'Role1'] = 'Captain Marvel'
about_movie_df.loc[about_movie_df['Actor'] == 'Brie Larson','Role2'] = 'Carol Danvers'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Steve Rogers', 'Role1'] = 'Captain America'
about_movie_df.loc[about_movie_df['Role1'] == 'Captain America','Role2'] = 'Steve Rogers'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Peter Quill', 'Role1'] = 'Star-Lord'
about_movie_df.loc[about_movie_df['Role1'] == 'Star-Lord','Role2'] = 'Peter Jason Quill'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Peter Parker', 'Role1'] = 'Spider-Man'
about_movie_df.loc[about_movie_df['Role1'] == 'Spider-Man','Role2'] = 'Peter Parker'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == 'Diana', 'Role1'] = 'Wonder Woman'
about_movie_df.loc[about_movie_df['Role1'] == 'Wonder Woman','Role2'] = 'Diana Prince'
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == "Jor-El", 'Role1'] = 'Jor-El'
about_movie_df.loc[about_movie_df['Role1'] == 'Jor-El','Role2'] = "Jor-El"
about_movie_df

about_movie_df.loc[about_movie_df['Role1'] == "T'Challa", 'Role1'] = 'Black Panther'
about_movie_df.loc[about_movie_df['Role1'] == 'Black Panther','Role2'] = "T'Challa"
about_movie_df

about_movie_df.loc[about_movie_df['Title'] == "Spider-Man: Far from Home", 'Title'] = 'Spider-Man: Far From Home'

about_movie_df.to_csv('about_movie.csv', index=False)
about_movie_df
Out[36]:
imdbID id_clean Title Actor Role1 Role2 Year Production Plot Poster
0 tt0109506 0109506 The Crow Brandon Lee Crow Eric Draven 1994 LionsGate Entertainment A man brutally murdered comes back to life as ... https://m.media-amazon.com/images/M/MV5BM2Y4ZG...
1 tt0112462 0112462 Batman Forever Val Kilmer Batman Bruce Wayne 1995 Warner Bros. Pictures Batman must battle former district attorney Ha... https://m.media-amazon.com/images/M/MV5BNDdjYm...
2 tt0411477 0411477 Hellboy II: The Golden Army Ron Perlman Hellboy Anung Un Rama 2008 Universal Pictures The mythical world starts a rebellion against ... https://m.media-amazon.com/images/M/MV5BMjA5Nz...
3 tt1981115 1981115 Thor: The Dark World Chris Hemsworth Thor Thor Odinson 2013 Walt Disney Pictures When the Dark Elves attempt to plunge the univ... https://m.media-amazon.com/images/M/MV5BMTQyNz...
4 tt0770828 0770828 Man of Steel Henry Cavill Superman Clark Kent 2013 Warner Bros. Pictures An alien child is evacuated from his dying wor... https://m.media-amazon.com/images/M/MV5BMTk5OD...
5 tt0800369 0800369 Thor Chris Hemsworth Thor Thor Odinson 2011 Paramount Pictures The powerful but arrogant god Thor is cast out... https://m.media-amazon.com/images/M/MV5BOGE4Nz...
6 tt0448115 0448115 Shazam! Zachary Levi Captain Marvel Billy Batson 2019 New Line Cinema A newly fostered young boy in search of his mo... https://m.media-amazon.com/images/M/MV5BYTE0Yj...
7 tt0376994 0376994 X-Men: The Last Stand Hugh Jackman Wolverine Logan 2006 20th Century Fox The human government develops a cure for mutat... https://m.media-amazon.com/images/M/MV5BNDBhND...
8 tt0478970 0478970 Ant-Man Paul Rudd Ant-Man Hank Pym 2015 Disney/Marvel Armed with a super-suit with the astonishing a... https://m.media-amazon.com/images/M/MV5BMjM2NT...
9 tt0948470 0948470 The Amazing Spider-Man Andrew Garfield Spider-Man Peter Parker 2012 Sony Pictures After Peter Parker is bitten by a genetically ... https://m.media-amazon.com/images/M/MV5BMjMyOT...
10 tt0458339 0458339 Captain America: The First Avenger Chris Evans Captain America Steve Rogers 2011 Paramount Pictures Steve Rogers, a rejected military soldier, tra... https://m.media-amazon.com/images/M/MV5BMTYzOT...
11 tt0348150 0348150 Superman Returns Brandon Routh Superman Clark Kent 2006 Warner Bros. Pictures Superman returns to Earth after spending five ... https://m.media-amazon.com/images/M/MV5BNzY2ZD...
12 tt1270798 1270798 X-Men: First Class James McAvoy Professor X Charles Francis Xavier 2011 20th Century Fox In the 1960s, superpowered humans Charles Xavi... https://m.media-amazon.com/images/M/MV5BMTg5OT...
13 tt0120903 0120903 X-Men Hugh Jackman Wolverine Logan 2000 20th Century Fox In a world where mutants (evolved super-powere... https://m.media-amazon.com/images/M/MV5BZmIyMD...
14 tt5095030 5095030 Ant-Man and the Wasp Paul Rudd Ant-Man Hank Pym 2018 Walt Disney Pictures As Scott Lang balances being both a superhero ... https://m.media-amazon.com/images/M/MV5BYjcyYT...
15 tt1477834 1477834 Aquaman Jason Momoa Aquaman Orin 2018 Warner Bros. Pictures Arthur Curry (Jason Momoa), the human-born hei... https://m.media-amazon.com/images/M/MV5BOTk5OD...
16 tt0413300 0413300 Spider-Man 3 Tobey Maguire Spider-Man Peter Parker 2007 Sony Pictures A strange black entity from another world bond... https://m.media-amazon.com/images/M/MV5BYTk3MD...
17 tt1211837 1211837 Doctor Strange Benedict Cumberbatch Doctor Strange Stephen Strange 2016 Walt Disney Pictures While on a journey of physical and spiritual h... https://m.media-amazon.com/images/M/MV5BNjgwNz...
18 tt0103776 0103776 Batman Returns Michael Keaton Batman Bruce Wayne 1992 Warner Bros. Pictures Batman returns to the big screen when a deform... https://m.media-amazon.com/images/M/MV5BOGZmYz...
19 tt0372784 0372784 Batman Begins Christian Bale Batman Bruce Wayne 2005 Warner Bros. Pictures After training with his mentor, Batman begins ... https://m.media-amazon.com/images/M/MV5BZmUwNG...
20 tt1877832 1877832 X-Men: Days of Future Past Hugh Jackman Wolverine Logan 2014 20th Century Fox The X-Men send Wolverine to the past in a desp... https://m.media-amazon.com/images/M/MV5BZGIzNW...
21 tt4633694 4633694 Spider-Man: Into the Spider-Verse Shameik Moore Spider-Man Peter Parker 2018 Sony Pictures Teen Miles Morales becomes the Spider-Man of h... https://m.media-amazon.com/images/M/MV5BMjMwND...
22 tt0081573 0081573 Superman II Gene Hackman Lex Luthor Lex Luthor 1980 Warner Bros. Pictures Superman agrees to sacrifice his powers to sta... https://m.media-amazon.com/images/M/MV5BMWUzND...
23 tt0290334 0290334 X2: X-Men United Patrick Stewart Professor X Charles Francis Xavier 2003 20th Century Fox When anti-mutant Colonel William Stryker kidna... https://m.media-amazon.com/images/M/MV5BNDk0Nj...
24 tt1228705 1228705 Iron Man 2 Robert Downey Jr. Iron Man Tony Stark 2010 Paramount Studios With the world now aware of his identity as Ir... https://m.media-amazon.com/images/M/MV5BMTM0MD...
25 tt5463162 5463162 Deadpool 2 Ryan Reynolds Juggernaut Cain Marko 2018 20th Century Fox Foul-mouthed mutant mercenary Wade Wilson (a.k... https://m.media-amazon.com/images/M/MV5BNjk1Nj...
26 tt3315342 3315342 Logan Hugh Jackman Wolverine Logan 2017 20th Century Fox In a future where mutants are nearly extinct, ... https://m.media-amazon.com/images/M/MV5BYzc5MT...
27 tt4154664 4154664 Captain Marvel Brie Larson Captain Marvel Carol Danvers 2019 Marvel Studios Carol Danvers becomes one of the universe's mo... https://m.media-amazon.com/images/M/MV5BMTE0YW...
28 tt1843866 1843866 Captain America: The Winter Soldier Chris Evans Captain America Steve Rogers 2014 Walt Disney Pictures As Steve Rogers struggles to embrace his role ... https://m.media-amazon.com/images/M/MV5BMzA2ND...
29 tt2395427 2395427 Avengers: Age of Ultron Robert Downey Jr. Iron Man Tony Stark 2015 Walt Disney Pictures When Tony Stark and Bruce Banner try to jump-s... https://m.media-amazon.com/images/M/MV5BMTM4OG...
30 tt3501632 3501632 Thor: Ragnarok Chris Hemsworth Thor Thor Odinson 2017 Walt Disney Pictures Imprisoned on the planet Sakaar, Thor must rac... https://m.media-amazon.com/images/M/MV5BMjMyND...
31 tt3896198 3896198 Guardians of the Galaxy Vol. 2 Chris Pratt Star-Lord Peter Jason Quill 2017 Walt Disney Pictures The Guardians struggle to keep together as a t... https://m.media-amazon.com/images/M/MV5BNjM0NT...
32 tt0096895 0096895 Batman Michael Keaton Batman Bruce Wayne 1989 Warner Bros. Pictures The Dark Knight of Gotham City begins his war ... https://m.media-amazon.com/images/M/MV5BMTYwNj...
33 tt1431045 1431045 Deadpool Ryan Reynolds Juggernaut Cain Marko 2016 20th Century Fox A wisecracking mercenary gets experimented on ... https://m.media-amazon.com/images/M/MV5BYzE5Mj...
34 tt1300854 1300854 Iron Man 3 Robert Downey Jr. Iron Man Tony Stark 2013 Walt Disney Pictures When Tony Stark's world is torn apart by a for... https://m.media-amazon.com/images/M/MV5BMjE5Mz...
35 tt6320628 6320628 Spider-Man: Far From Home Tom Holland Spider-Man Peter Parker 2019 Sony Pictures Following the events of Avengers: Endgame (201... https://m.media-amazon.com/images/M/MV5BMGZlNT...
36 tt2250912 2250912 Spider-Man: Homecoming Tom Holland Spider-Man Peter Parker 2017 Sony Pictures Peter Parker balances his life as an ordinary ... https://m.media-amazon.com/images/M/MV5BNTk4OD...
37 tt2015381 2015381 Guardians of the Galaxy Chris Pratt Star-Lord Peter Jason Quill 2014 Walt Disney Pictures A group of intergalactic criminals must pull t... https://m.media-amazon.com/images/M/MV5BMTAwMj...
38 tt1345836 1345836 The Dark Knight Rises Christian Bale Batman Bruce Wayne 2012 Warner Bros. Pictures Eight years after the Joker's reign of anarchy... https://m.media-amazon.com/images/M/MV5BMTk4OD...
39 tt3498820 3498820 Captain America: Civil War Chris Evans Captain America Steve Rogers 2016 Walt Disney Pictures Political involvement in the Avengers' affairs... https://m.media-amazon.com/images/M/MV5BMjQ0MT...
40 tt0371746 0371746 Iron Man Robert Downey Jr. Iron Man Tony Stark 2008 Paramount Pictures After being held captive in an Afghan cave, bi... https://m.media-amazon.com/images/M/MV5BMTczNT...
41 tt4154756 4154756 Avengers: Infinity War Robert Downey Jr. Iron Man Tony Stark 2018 Walt Disney Pictures The Avengers and their allies must be willing ... https://m.media-amazon.com/images/M/MV5BMjMxNj...
42 tt0451279 0451279 Wonder Woman Gal Gadot Wonder Woman Diana Prince 2017 Warner Bros. Pictures When a pilot crashes and tells of conflict in ... https://m.media-amazon.com/images/M/MV5BNDFmZj...
43 tt0316654 0316654 Spider-Man 2 Tobey Maguire Spider-Man Peter Parker 2004 Sony Pictures Peter Parker is beset with troubles in his fai... https://m.media-amazon.com/images/M/MV5BMzY2OD...
44 tt0145487 0145487 Spider-Man Tobey Maguire Spider-Man Peter Parker 2002 Columbia Pictures When bitten by a genetically modified spider, ... https://m.media-amazon.com/images/M/MV5BZDEyN2...
45 tt0078346 0078346 Superman Marlon Brando Jor-El Jor-El 1978 Warner Bros. Pictures An alien orphan is sent from his dying planet ... https://m.media-amazon.com/images/M/MV5BMzA0YW...
46 tt0848228 0848228 The Avengers Robert Downey Jr. Iron Man Tony Stark 2012 Walt Disney Pictures Earth's mightiest heroes must come together an... https://m.media-amazon.com/images/M/MV5BNDYxNj...
47 tt4154796 4154796 Avengers: Endgame Robert Downey Jr. Iron Man Tony Stark 2019 Marvel Studios After the devastating events of Avengers: Infi... https://m.media-amazon.com/images/M/MV5BMTc5MD...
48 tt1825683 1825683 Black Panther Chadwick Boseman Black Panther T'Challa 2018 Marvel Studios T'Challa, heir to the hidden but advanced king... https://m.media-amazon.com/images/M/MV5BMTg1MT...
49 tt0468569 0468569 The Dark Knight Christian Bale Batman Bruce Wayne 2008 Warner Bros. Pictures/Legendary When the menace known as the Joker wreaks havo... https://m.media-amazon.com/images/M/MV5BMTMxNT...
In [37]:
# Adding a missing Hero - the Crow

the_crow_dict = {
        "name" : ['Crow'],
        "fullName":['Eric Draven'],
        "gender":['Male'],
        "eyeColor" :['Blue'],
        "height":['avr'],
        "weight":['avr'],
        "race" :['human'],
        "placeOfBirth": ['Earth'],
        "work" : ['a rock musician'],
        "images": ['https://upload.wikimedia.org/wikipedia/en/3/39/Crow_ver2.jpg'],
        "intelligence":['high'],
        "power":['high']
}



the_crow_df = pd.DataFrame(the_crow_dict)
print(the_crow_df.count())
the_crow_df.head()
name            1
fullName        1
gender          1
eyeColor        1
height          1
weight          1
race            1
placeOfBirth    1
work            1
images          1
intelligence    1
power           1
dtype: int64
Out[37]:
name fullName gender eyeColor height weight race placeOfBirth work images intelligence power
0 Crow Eric Draven Male Blue avr avr human Earth a rock musician https://upload.wikimedia.org/wikipedia/en/3/39... high high
In [38]:
# Appending the Crow info to the new_hero_df
new_hero_df = hero_df.append(the_crow_df)

# Checking, that a Crow hero is in dataset   
new_hero_df.loc[new_hero_df['name'] == 'Crow']
# new_hero_df
Out[38]:
name fullName gender eyeColor height weight race placeOfBirth work images intelligence power
0 Crow Eric Draven Male Blue avr avr human Earth a rock musician https://upload.wikimedia.org/wikipedia/en/3/39... high high
In [39]:
# Adding a missing Hero - the Jor-El
jor_el_dict = {
        "name" : ['Jor-El'],
        "fullName":['Jor-El'],
        "gender":['Male'],
        "eyeColor" :['Blue'],
        "height":['avr'],
        "weight":['avr'],
        "race" :['human'],
        "placeOfBirth": ['Krypton,'],
        "work" : ['a scientist'],
        "images": ['https://vignette.wikia.nocookie.net/supermanrebirth/images/3/3d/Marlon_Brando_Jor-El.jpg/revision/latest?cb=20130224095531'],
        "intelligence":['high'],
        "power":['high']
}



jor_el_df = pd.DataFrame(jor_el_dict)
print(jor_el_df.count())
jor_el_df.head()
name            1
fullName        1
gender          1
eyeColor        1
height          1
weight          1
race            1
placeOfBirth    1
work            1
images          1
intelligence    1
power           1
dtype: int64
Out[39]:
name fullName gender eyeColor height weight race placeOfBirth work images intelligence power
0 Jor-El Jor-El Male Blue avr avr human Krypton, a scientist https://vignette.wikia.nocookie.net/supermanre... high high
In [40]:
# Adding missing hero Jor-El to new_hero_df data set
new_hero_df = new_hero_df.append(jor_el_df)

    
# new_df.loc[new_df['name'] == 'Jor-El']
new_hero_df.reset_index(drop = True)
Out[40]:
name fullName gender eyeColor height weight race placeOfBirth work images intelligence power
0 A-Bomb Richard Milhouse Jones Male Yellow 6'8 980 lb Human Scarsdale, Arizona Musician, adventurer, author; formerly talk sh... https://cdn.rawgit.com/akabab/superhero-api/0.... 38 24
1 Abe Sapien Abraham Sapien Male Blue 6'3 145 lb Icthyo Sapien - Paranormal Investigator https://cdn.rawgit.com/akabab/superhero-api/0.... 88 100
2 Abin Sur Male Blue 6'1 200 lb Ungaran Ungara Green Lantern, former history professor https://cdn.rawgit.com/akabab/superhero-api/0.... 50 99
3 Abomination Emil Blonsky Male Green 6'8 980 lb Human / Radiation Zagreb, Yugoslavia Ex-Spy https://cdn.rawgit.com/akabab/superhero-api/0.... 63 62
4 Abraxas Abraxas Male Blue - - lb Cosmic Entity Within Eternity Dimensional destroyer https://cdn.rawgit.com/akabab/superhero-api/0.... 88 100
... ... ... ... ... ... ... ... ... ... ... ... ...
558 Yellowjacket II Rita DeMara Female Blue 5'5 115 lb Human - Adventurer; former criminal, electronics engineer https://cdn.rawgit.com/akabab/superhero-api/0.... 50 31
559 Ymir Ymir Male White 1000 - lb Frost Giant Niffleheim - https://cdn.rawgit.com/akabab/superhero-api/0.... 50 98
560 Yoda Yoda Male Brown 2'2 38 lb Yoda's species - - https://cdn.rawgit.com/akabab/superhero-api/0.... 88 100
561 Crow Eric Draven Male Blue avr avr human Earth a rock musician https://upload.wikimedia.org/wikipedia/en/3/39... high high
562 Jor-El Jor-El Male Blue avr avr human Krypton, a scientist https://vignette.wikia.nocookie.net/supermanre... high high

563 rows × 12 columns

In [41]:
# Checking wich Heroes appeared the most in the top 50 SuperHero Movies
group_hero = about_movie_df.groupby(['Role1', 'Role2'])['Role1'].count()
group_hero_df = pd.DataFrame(group_hero)
group_hero_df = group_hero_df.rename(columns={'Role1':'Count'})
group_hero_df = group_hero_df.sort_values(by=['Count'], ascending=False)
group_hero_df
# Iron Man and Spider-Man appeared the most.
Out[41]:
Count
Role1 Role2
Iron Man Tony Stark 7
Spider-Man Peter Parker 7
Batman Bruce Wayne 6
Wolverine Logan 4
Captain America Steve Rogers 3
Thor Thor Odinson 3
Juggernaut Cain Marko 2
Superman Clark Kent 2
Star-Lord Peter Jason Quill 2
Professor X Charles Francis Xavier 2
Ant-Man Hank Pym 2
Jor-El Jor-El 1
Aquaman Orin 1
Lex Luthor Lex Luthor 1
Hellboy Anung Un Rama 1
Doctor Strange Stephen Strange 1
Crow Eric Draven 1
Captain Marvel Carol Danvers 1
Billy Batson 1
Black Panther T'Challa 1
Wonder Woman Diana Prince 1
In [42]:
# Joining about_movie_df and movies_df on Title and title 
# Group by Hero, to see wich Hero brings the best revenue.
movie_actor_role_df = pd.merge(left=about_movie_df, right=movies_df, left_on='Title', right_on='title')
movie_actor_role_df
Out[42]:
imdbID id_clean Title Actor Role1 Role2 Year Production Plot Poster rank title date rottenTomatoes boxOffice rewatchability totalScore image
0 tt0109506 0109506 The Crow Brandon Lee Crow Eric Draven 1994 LionsGate Entertainment A man brutally murdered comes back to life as ... https://m.media-amazon.com/images/M/MV5BM2Y4ZG... 50 The Crow 1994 82% 83.3 6.25 125 https://hardrefreshcdn.com/public/media/superh...
1 tt0112462 0112462 Batman Forever Val Kilmer Batman Bruce Wayne 1995 Warner Bros. Pictures Batman must battle former district attorney Ha... https://m.media-amazon.com/images/M/MV5BNDdjYm... 49 Batman Forever 1995 41% 295.0 5.82 130 https://hardrefreshcdn.com/public/media/superh...
2 tt0411477 0411477 Hellboy II: The Golden Army Ron Perlman Hellboy Anung Un Rama 2008 Universal Pictures The mythical world starts a rebellion against ... https://m.media-amazon.com/images/M/MV5BMjA5Nz... 48 Hellboy II: The Golden Army 2008 85% 87.0 7.00 134 https://hardrefreshcdn.com/public/media/superh...
3 tt1981115 1981115 Thor: The Dark World Chris Hemsworth Thor Thor Odinson 2013 Walt Disney Pictures When the Dark Elves attempt to plunge the univ... https://m.media-amazon.com/images/M/MV5BMTQyNz... 47 Thor: The Dark World 2013 66% 219.0 4.45 134 https://hardrefreshcdn.com/public/media/superh...
4 tt0770828 0770828 Man of Steel Henry Cavill Superman Clark Kent 2013 Warner Bros. Pictures An alien child is evacuated from his dying wor... https://m.media-amazon.com/images/M/MV5BMTk5OD... 46 Man of Steel 2013 55% 309.0 3.91 139 https://hardrefreshcdn.com/public/media/superh...
5 tt0800369 0800369 Thor Chris Hemsworth Thor Thor Odinson 2011 Paramount Pictures The powerful but arrogant god Thor is cast out... https://m.media-amazon.com/images/M/MV5BOGE4Nz... 45 Thor 2011 77% 199.0 5.09 142 https://hardrefreshcdn.com/public/media/superh...
6 tt0448115 0448115 Shazam! Zachary Levi Captain Marvel Billy Batson 2019 New Line Cinema A newly fostered young boy in search of his mo... https://m.media-amazon.com/images/M/MV5BYTE0Yj... 44 Shazam! 2019 91% 140.4 4.00 143 https://hardrefreshcdn.com/public/media/superh...
7 tt0376994 0376994 X-Men: The Last Stand Hugh Jackman Wolverine Logan 2006 20th Century Fox The human government develops a cure for mutat... https://m.media-amazon.com/images/M/MV5BNDBhND... 43 X-Men: The Last Stand 2006 58% 286.0 4.70 144 https://hardrefreshcdn.com/public/media/superh...
8 tt0478970 0478970 Ant-Man Paul Rudd Ant-Man Hank Pym 2015 Disney/Marvel Armed with a super-suit with the astonishing a... https://m.media-amazon.com/images/M/MV5BMjM2NT... 42 Ant-Man 2015 82% 183.0 7.00 150 https://hardrefreshcdn.com/public/media/superh...
9 tt0948470 0948470 The Amazing Spider-Man Andrew Garfield Spider-Man Peter Parker 2012 Sony Pictures After Peter Parker is bitten by a genetically ... https://m.media-amazon.com/images/M/MV5BMjMyOT... 41 The Amazing Spider-Man 2012 72% 282.0 4.36 151 https://hardrefreshcdn.com/public/media/superh...
10 tt0458339 0458339 Captain America: The First Avenger Chris Evans Captain America Steve Rogers 2011 Paramount Pictures Steve Rogers, a rejected military soldier, tra... https://m.media-amazon.com/images/M/MV5BMTYzOT... 40 Captain America: The First Avenger 2011 80% 194.0 7.45 151 https://hardrefreshcdn.com/public/media/superh...
11 tt0348150 0348150 Superman Returns Brandon Routh Superman Clark Kent 2006 Warner Bros. Pictures Superman returns to Earth after spending five ... https://m.media-amazon.com/images/M/MV5BNzY2ZD... 39 Superman Returns 2006 76% 286.0 3.91 152 https://hardrefreshcdn.com/public/media/superh...
12 tt1270798 1270798 X-Men: First Class James McAvoy Professor X Charles Francis Xavier 2011 20th Century Fox In the 1960s, superpowered humans Charles Xavi... https://m.media-amazon.com/images/M/MV5BMTg5OT... 38 X-Men: First Class 2011 86% 161.0 9.09 154 https://hardrefreshcdn.com/public/media/superh...
13 tt0120903 0120903 X-Men Hugh Jackman Wolverine Logan 2000 20th Century Fox In a world where mutants (evolved super-powere... https://m.media-amazon.com/images/M/MV5BZmIyMD... 37 X-Men 2000 81% 223.0 7.40 157 https://hardrefreshcdn.com/public/media/superh...
14 tt5095030 5095030 Ant-Man and the Wasp Paul Rudd Ant-Man Hank Pym 2018 Walt Disney Pictures As Scott Lang balances being both a superhero ... https://m.media-amazon.com/images/M/MV5BYjcyYT... 36 Ant-Man and the Wasp 2018 88% 217.0 3.80 157 https://hardrefreshcdn.com/public/media/superh...
15 tt1477834 1477834 Aquaman Jason Momoa Aquaman Orin 2018 Warner Bros. Pictures Arthur Curry (Jason Momoa), the human-born hei... https://m.media-amazon.com/images/M/MV5BOTk5OD... 35 Aquaman 2018 64% 335.0 6.50 159 https://hardrefreshcdn.com/public/media/superh...
16 tt0413300 0413300 Spider-Man 3 Tobey Maguire Spider-Man Peter Parker 2007 Sony Pictures A strange black entity from another world bond... https://m.media-amazon.com/images/M/MV5BYTk3MD... 34 Spider-Man 3 2007 63% 399.0 4.09 159 https://hardrefreshcdn.com/public/media/superh...
17 tt1211837 1211837 Doctor Strange Benedict Cumberbatch Doctor Strange Stephen Strange 2016 Walt Disney Pictures While on a journey of physical and spiritual h... https://m.media-amazon.com/images/M/MV5BNjgwNz... 33 Doctor Strange 2016 89% 233.0 5.00 166 https://hardrefreshcdn.com/public/media/superh...
18 tt0103776 0103776 Batman Returns Michael Keaton Batman Bruce Wayne 1992 Warner Bros. Pictures Batman returns to the big screen when a deform... https://m.media-amazon.com/images/M/MV5BOGZmYz... 32 Batman Returns 1992 81% 283.0 6.80 168 https://hardrefreshcdn.com/public/media/superh...
19 tt0372784 0372784 Batman Begins Christian Bale Batman Bruce Wayne 2005 Warner Bros. Pictures After training with his mentor, Batman begins ... https://m.media-amazon.com/images/M/MV5BZmUwNG... 31 Batman Begins 2005 84% 256.0 8.00 169 https://hardrefreshcdn.com/public/media/superh...
20 tt1877832 1877832 X-Men: Days of Future Past Hugh Jackman Wolverine Logan 2014 20th Century Fox The X-Men send Wolverine to the past in a desp... https://m.media-amazon.com/images/M/MV5BZGIzNW... 30 X-Men: Days of Future Past 2014 90% 244.0 6.09 170 https://hardrefreshcdn.com/public/media/superh...
21 tt4633694 4633694 Spider-Man: Into the Spider-Verse Shameik Moore Spider-Man Peter Parker 2018 Sony Pictures Teen Miles Morales becomes the Spider-Man of h... https://m.media-amazon.com/images/M/MV5BMjMwND... 29 Spider-Man: Into the Spider-Verse 2018 97% 190.0 10.0 170 https://hardrefreshcdn.com/public/media/superh...
22 tt0081573 0081573 Superman II Gene Hackman Lex Luthor Lex Luthor 1980 Warner Bros. Pictures Superman agrees to sacrifice his powers to sta... https://m.media-amazon.com/images/M/MV5BMWUzND... 28 Superman II 1981 87% 290.0 4.33 170 https://hardrefreshcdn.com/public/media/superh...
23 tt0290334 0290334 X2: X-Men United Patrick Stewart Professor X Charles Francis Xavier 2003 20th Century Fox When anti-mutant Colonel William Stryker kidna... https://m.media-amazon.com/images/M/MV5BNDk0Nj... 27 X2: X-Men United 2003 86% 287.0 5.60 171 https://hardrefreshcdn.com/public/media/superh...
24 tt1228705 1228705 Iron Man 2 Robert Downey Jr. Iron Man Tony Stark 2010 Paramount Studios With the world now aware of his identity as Ir... https://m.media-amazon.com/images/M/MV5BMTM0MD... 26 Iron Man 2 2010 73% 353.0 5.64 172 https://hardrefreshcdn.com/public/media/superh...
25 tt5463162 5463162 Deadpool 2 Ryan Reynolds Juggernaut Cain Marko 2018 20th Century Fox Foul-mouthed mutant mercenary Wade Wilson (a.k... https://m.media-amazon.com/images/M/MV5BNjk1Nj... 25 Deadpool 2 2018 83% 325.0 5.20 172 https://hardrefreshcdn.com/public/media/superh...
26 tt3315342 3315342 Logan Hugh Jackman Wolverine Logan 2017 20th Century Fox In a future where mutants are nearly extinct, ... https://m.media-amazon.com/images/M/MV5BYzc5MT... 24 Logan 2017 93% 226.0 9.27 174 https://hardrefreshcdn.com/public/media/superh...
27 tt4154664 4154664 Captain Marvel Brie Larson Captain Marvel Carol Danvers 2019 Marvel Studios Carol Danvers becomes one of the universe's mo... https://m.media-amazon.com/images/M/MV5BMTE0YW... 23 Captain Marvel 2019 78% 427.0 2.50 176 https://hardrefreshcdn.com/public/media/superh...
28 tt1843866 1843866 Captain America: The Winter Soldier Chris Evans Captain America Steve Rogers 2014 Walt Disney Pictures As Steve Rogers struggles to embrace his role ... https://m.media-amazon.com/images/M/MV5BMzA2ND... 22 Captain America: The Winter Soldier 2014 89% 271.0 7.70 176 https://hardrefreshcdn.com/public/media/superh...
29 tt2395427 2395427 Avengers: Age of Ultron Robert Downey Jr. Iron Man Tony Stark 2015 Walt Disney Pictures When Tony Stark and Bruce Banner try to jump-s... https://m.media-amazon.com/images/M/MV5BMTM4OG... 21 Avengers: Age of Ultron 2015 75% 467.0 5.18 180 https://hardrefreshcdn.com/public/media/superh...
30 tt3501632 3501632 Thor: Ragnarok Chris Hemsworth Thor Thor Odinson 2017 Walt Disney Pictures Imprisoned on the planet Sakaar, Thor must rac... https://m.media-amazon.com/images/M/MV5BMjMyND... 20 Thor: Ragnarok 2017 93% 315.0 7.50 183 https://hardrefreshcdn.com/public/media/superh...
31 tt3896198 3896198 Guardians of the Galaxy Vol. 2 Chris Pratt Star-Lord Peter Jason Quill 2017 Walt Disney Pictures The Guardians struggle to keep together as a t... https://m.media-amazon.com/images/M/MV5BNjM0NT... 19 Guardians of the Galaxy Vol. 2 2017 82% 389.0 6.82 186 https://hardrefreshcdn.com/public/media/superh...
32 tt0096895 0096895 Batman Michael Keaton Batman Bruce Wayne 1989 Warner Bros. Pictures The Dark Knight of Gotham City begins his war ... https://m.media-amazon.com/images/M/MV5BMTYwNj... 18 Batman 1989 72% 493.0 7.50 186 https://hardrefreshcdn.com/public/media/superh...
33 tt1431045 1431045 Deadpool Ryan Reynolds Juggernaut Cain Marko 2016 20th Century Fox A wisecracking mercenary gets experimented on ... https://m.media-amazon.com/images/M/MV5BYzE5Mj... 17 Deadpool 2016 84% 363.0 7.36 187 https://hardrefreshcdn.com/public/media/superh...
34 tt1300854 1300854 Iron Man 3 Robert Downey Jr. Iron Man Tony Stark 2013 Walt Disney Pictures When Tony Stark's world is torn apart by a for... https://m.media-amazon.com/images/M/MV5BMjE5Mz... 16 Iron Man 3 2013 79% 434.0 6.91 187 https://hardrefreshcdn.com/public/media/superh...
35 tt6320628 6320628 Spider-Man: Far From Home Tom Holland Spider-Man Peter Parker 2019 Sony Pictures Following the events of Avengers: Endgame (201... https://m.media-amazon.com/images/M/MV5BMGZlNT... 15 Spider-Man: Far From Home 2019 90% 373.0 7.00 189 https://hardrefreshcdn.com/public/media/superh...
36 tt2250912 2250912 Spider-Man: Homecoming Tom Holland Spider-Man Peter Parker 2017 Sony Pictures Peter Parker balances his life as an ordinary ... https://m.media-amazon.com/images/M/MV5BNTk4OD... 14 Spider-Man: Homecoming 2017 92% 333.0 7.45 191 https://hardrefreshcdn.com/public/media/superh...
37 tt2015381 2015381 Guardians of the Galaxy Chris Pratt Star-Lord Peter Jason Quill 2014 Walt Disney Pictures A group of intergalactic criminals must pull t... https://m.media-amazon.com/images/M/MV5BMTAwMj... 13 Guardians of the Galaxy 2014 91% 348.0 7.55 192 https://hardrefreshcdn.com/public/media/superh...
38 tt1345836 1345836 The Dark Knight Rises Christian Bale Batman Bruce Wayne 2012 Warner Bros. Pictures Eight years after the Joker's reign of anarchy... https://m.media-amazon.com/images/M/MV5BMTk4OD... 12 The Dark Knight Rises 2012 87% 482.0 6.91 193 https://hardrefreshcdn.com/public/media/superh...
39 tt3498820 3498820 Captain America: Civil War Chris Evans Captain America Steve Rogers 2016 Walt Disney Pictures Political involvement in the Avengers' affairs... https://m.media-amazon.com/images/M/MV5BMjQ0MT... 11 Captain America: Civil War 2016 90% 408.0 7.55 196 https://hardrefreshcdn.com/public/media/superh...
40 tt0371746 0371746 Iron Man Robert Downey Jr. Iron Man Tony Stark 2008 Paramount Pictures After being held captive in an Afghan cave, bi... https://m.media-amazon.com/images/M/MV5BMTczNT... 10 Iron Man 2008 94% 364.0 7.82 197 https://hardrefreshcdn.com/public/media/superh...
41 tt4154756 4154756 Avengers: Infinity War Robert Downey Jr. Iron Man Tony Stark 2018 Walt Disney Pictures The Avengers and their allies must be willing ... https://m.media-amazon.com/images/M/MV5BMjMxNj... 9 Avengers: Infinity War 2018 84% 679.0 8.0 198 https://hardrefreshcdn.com/public/media/superh...
42 tt0451279 0451279 Wonder Woman Gal Gadot Wonder Woman Diana Prince 2017 Warner Bros. Pictures When a pilot crashes and tells of conflict in ... https://m.media-amazon.com/images/M/MV5BNDFmZj... 8 Wonder Woman 2017 92% 412.0 8.00 201 https://hardrefreshcdn.com/public/media/superh...
43 tt0316654 0316654 Spider-Man 2 Tobey Maguire Spider-Man Peter Parker 2004 Sony Pictures Peter Parker is beset with troubles in his fai... https://m.media-amazon.com/images/M/MV5BMzY2OD... 7 Spider-Man 2 2004 94% 483.0 5.91 201 https://hardrefreshcdn.com/public/media/superh...
44 tt0145487 0145487 Spider-Man Tobey Maguire Spider-Man Peter Parker 2002 Columbia Pictures When bitten by a genetically modified spider, ... https://m.media-amazon.com/images/M/MV5BZDEyN2... 6 Spider-Man 2002 89% 550.0 7.27 205 https://hardrefreshcdn.com/public/media/superh...
45 tt0078346 0078346 Superman Marlon Brando Jor-El Jor-El 1978 Warner Bros. Pictures An alien orphan is sent from his dying planet ... https://m.media-amazon.com/images/M/MV5BMzA0YW... 5 Superman 1978 93% 502.0 5.67 206 https://hardrefreshcdn.com/public/media/superh...
46 tt0848228 0848228 The Avengers Robert Downey Jr. Iron Man Tony Stark 2012 Walt Disney Pictures Earth's mightiest heroes must come together an... https://m.media-amazon.com/images/M/MV5BNDYxNj... 4 The Avengers 2012 92% 671.0 7.36 210 https://hardrefreshcdn.com/public/media/superh...
47 tt4154796 4154796 Avengers: Endgame Robert Downey Jr. Iron Man Tony Stark 2019 Marvel Studios After the devastating events of Avengers: Infi... https://m.media-amazon.com/images/M/MV5BMTc5MD... 3 Avengers: Endgame 2019 94% 858.0 7.50 212 https://hardrefreshcdn.com/public/media/superh...
48 tt1825683 1825683 Black Panther Chadwick Boseman Black Panther T'Challa 2018 Marvel Studios T'Challa, heir to the hidden but advanced king... https://m.media-amazon.com/images/M/MV5BMTg1MT... 2 Black Panther 2018 96% 700.0 9.60 213 https://hardrefreshcdn.com/public/media/superh...
49 tt0468569 0468569 The Dark Knight Christian Bale Batman Bruce Wayne 2008 Warner Bros. Pictures/Legendary When the menace known as the Joker wreaks havo... https://m.media-amazon.com/images/M/MV5BMTMxNT... 1 The Dark Knight 2008 94% 612.0 9.27 214 https://hardrefreshcdn.com/public/media/superh...
In [43]:
# Delete duplicate columns
movie_actor_role_df = movie_actor_role_df.drop(['id_clean', 'date', 'rewatchability', 'rottenTomatoes', 'totalScore', 'image'] , axis=1)
movie_actor_role_df.head()
Out[43]:
imdbID Title Actor Role1 Role2 Year Production Plot Poster rank title boxOffice
0 tt0109506 The Crow Brandon Lee Crow Eric Draven 1994 LionsGate Entertainment A man brutally murdered comes back to life as ... https://m.media-amazon.com/images/M/MV5BM2Y4ZG... 50 The Crow 83.3
1 tt0112462 Batman Forever Val Kilmer Batman Bruce Wayne 1995 Warner Bros. Pictures Batman must battle former district attorney Ha... https://m.media-amazon.com/images/M/MV5BNDdjYm... 49 Batman Forever 295.0
2 tt0411477 Hellboy II: The Golden Army Ron Perlman Hellboy Anung Un Rama 2008 Universal Pictures The mythical world starts a rebellion against ... https://m.media-amazon.com/images/M/MV5BMjA5Nz... 48 Hellboy II: The Golden Army 87.0
3 tt1981115 Thor: The Dark World Chris Hemsworth Thor Thor Odinson 2013 Walt Disney Pictures When the Dark Elves attempt to plunge the univ... https://m.media-amazon.com/images/M/MV5BMTQyNz... 47 Thor: The Dark World 219.0
4 tt0770828 Man of Steel Henry Cavill Superman Clark Kent 2013 Warner Bros. Pictures An alien child is evacuated from his dying wor... https://m.media-amazon.com/images/M/MV5BMTk5OD... 46 Man of Steel 309.0
In [44]:
# Group by hero to find the top box office
group_hero_revenue = movie_actor_role_df.groupby('Role1')['boxOffice'].sum()
group_hero_revenue_df = pd.DataFrame(group_hero_revenue)
group_hero_revenue_df = group_hero_revenue_df.sort_values(by=['boxOffice'], ascending=False)
group_hero_revenue_df= group_hero_revenue_df.reset_index()
group_hero_revenue_df
# Iron Man is the most valuable hero.
Out[44]:
Role1 boxOffice
0 Iron Man 3826.0
1 Spider-Man 2610.0
2 Batman 2421.0
3 Wolverine 979.0
4 Captain America 873.0
5 Star-Lord 737.0
6 Thor 733.0
7 Black Panther 700.0
8 Juggernaut 688.0
9 Superman 595.0
10 Captain Marvel 567.4
11 Jor-El 502.0
12 Professor X 448.0
13 Wonder Woman 412.0
14 Ant-Man 400.0
15 Aquaman 335.0
16 Lex Luthor 290.0
17 Doctor Strange 233.0
18 Hellboy 87.0
19 Crow 83.3
In [45]:
# Group by production to find the most valuable company
group_production_revenue = movie_actor_role_df.groupby('Production')['boxOffice'].sum()
group_production_revenue = pd.DataFrame(group_production_revenue)
group_production_revenue = group_production_revenue.sort_values(by=['boxOffice'], ascending=False)
group_production_revenue= group_production_revenue.reset_index()
group_production_revenue
# Walt Disney Pictures is the most profitable company
Out[45]:
Production boxOffice
0 Walt Disney Pictures 4651.0
1 Warner Bros. Pictures 3943.0
2 20th Century Fox 2115.0
3 Sony Pictures 2060.0
4 Marvel Studios 1985.0
5 Paramount Pictures 757.0
6 Warner Bros. Pictures/Legendary 612.0
7 Columbia Pictures 550.0
8 Paramount Studios 353.0
9 Disney/Marvel 183.0
10 New Line Cinema 140.4
11 Universal Pictures 87.0
12 LionsGate Entertainment 83.3
In [46]:
#Bar chart for each Hero and revenue
import plotly.express as px
df = group_hero_revenue_df
fig = px.bar(df, x='Role1', y='boxOffice')

fig.update_xaxes(title_text='Hero')
fig.update_yaxes(title_text='Box Office ($million)')

fig.update_layout(
    title={
        'text':'Box Office per Hero',
        'y':0.95,
        'x':0.4,
        'xanchor': 'center',
        'yanchor': 'top'}
)


fig.show()
In [47]:
# Checking wich production company appeared the most in the top 50 SuperHero Movies
group_production = about_movie_df.groupby('Production')['Production'].count()
group_production_df = pd.DataFrame(group_production)
group_production_df = group_production_df.rename(columns={'Production':'Count'})
group_production_df = group_production_df.sort_values(by=['Count'], ascending=False)
group_production_df
Out[47]:
Count
Production
Walt Disney Pictures 12
Warner Bros. Pictures 11
20th Century Fox 8
Sony Pictures 6
Marvel Studios 3
Paramount Pictures 3
Columbia Pictures 1
Disney/Marvel 1
LionsGate Entertainment 1
New Line Cinema 1
Paramount Studios 1
Universal Pictures 1
Warner Bros. Pictures/Legendary 1
In [57]:
#Bar chart for each production studio vs revenue

import plotly.express as px
df = group_production_revenue
fig = px.bar(df, x='Production', y='boxOffice')

fig.update_xaxes(title_text='Production Studio')
fig.update_yaxes(title_text='Box Office ($million)')

fig.update_layout(
    title={
        'text':'Box Office per Production Studio',
        'y':0.95,
        'x':0.4,
        'xanchor': 'center',
        'yanchor': 'top'}
)


fig.show(renderer="notebook")

Data Analysis (Question 3)

  1. Based on the data presented above we can see that the most valuable superhero is Iron Man with the total box office of 3826 million dollars. Iron man was in 7 movies, and they represent 14% of all our movies.
  2. The most profitable company is Walt Disney Pictures. It created 12 movies (24% of all our movies) with the total box office of 4651 million dollars.
  3. Base on this results, Walt Disney will keep producing superhero movies and traders will be bullish on Walt Disney stock, it means that they thinks the price of Walt Disney stock is going to go up.
In [49]:
# PART 4 =========================== Final ======================
# Joining  movie_actor_role_df with new_hero_df on Role1 and name. 
# It will create final dataset, which will have info about the best 50 Superheroes movies, main actor for each movie 
# and the main hero for each movie.

movie_actor_hero_df = pd.merge(left=movie_actor_role_df, right=new_hero_df, left_on=['Role1', 'Role2'], right_on=['name', 'fullName'])
movie_actor_hero_df
Out[49]:
imdbID Title Actor Role1 Role2 Year Production Plot Poster rank ... gender eyeColor height weight race placeOfBirth work images intelligence power
0 tt0109506 The Crow Brandon Lee Crow Eric Draven 1994 LionsGate Entertainment A man brutally murdered comes back to life as ... https://m.media-amazon.com/images/M/MV5BM2Y4ZG... 50 ... Male Blue avr avr human Earth a rock musician https://upload.wikimedia.org/wikipedia/en/3/39... high high
1 tt0112462 Batman Forever Val Kilmer Batman Bruce Wayne 1995 Warner Bros. Pictures Batman must battle former district attorney Ha... https://m.media-amazon.com/images/M/MV5BNDdjYm... 49 ... Male blue 6'2 210 lb Human Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0.... 100 47
2 tt0103776 Batman Returns Michael Keaton Batman Bruce Wayne 1992 Warner Bros. Pictures Batman returns to the big screen when a deform... https://m.media-amazon.com/images/M/MV5BOGZmYz... 32 ... Male blue 6'2 210 lb Human Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0.... 100 47
3 tt0372784 Batman Begins Christian Bale Batman Bruce Wayne 2005 Warner Bros. Pictures After training with his mentor, Batman begins ... https://m.media-amazon.com/images/M/MV5BZmUwNG... 31 ... Male blue 6'2 210 lb Human Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0.... 100 47
4 tt0096895 Batman Michael Keaton Batman Bruce Wayne 1989 Warner Bros. Pictures The Dark Knight of Gotham City begins his war ... https://m.media-amazon.com/images/M/MV5BMTYwNj... 18 ... Male blue 6'2 210 lb Human Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0.... 100 47
5 tt1345836 The Dark Knight Rises Christian Bale Batman Bruce Wayne 2012 Warner Bros. Pictures Eight years after the Joker's reign of anarchy... https://m.media-amazon.com/images/M/MV5BMTk4OD... 12 ... Male blue 6'2 210 lb Human Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0.... 100 47
6 tt0468569 The Dark Knight Christian Bale Batman Bruce Wayne 2008 Warner Bros. Pictures/Legendary When the menace known as the Joker wreaks havo... https://m.media-amazon.com/images/M/MV5BMTMxNT... 1 ... Male blue 6'2 210 lb Human Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0.... 100 47
7 tt0411477 Hellboy II: The Golden Army Ron Perlman Hellboy Anung Un Rama 2008 Universal Pictures The mythical world starts a rebellion against ... https://m.media-amazon.com/images/M/MV5BMjA5Nz... 48 ... Male Gold 8'6 350 lb Demon - - https://cdn.rawgit.com/akabab/superhero-api/0.... 63 73
8 tt1981115 Thor: The Dark World Chris Hemsworth Thor Thor Odinson 2013 Walt Disney Pictures When the Dark Elves attempt to plunge the univ... https://m.media-amazon.com/images/M/MV5BMTQyNz... 47 ... Male Blue 6'6 640 lb Asgardian Asgard King of Asgard; formerly EMS Technician; Physi... https://cdn.rawgit.com/akabab/superhero-api/0.... 69 100
9 tt0800369 Thor Chris Hemsworth Thor Thor Odinson 2011 Paramount Pictures The powerful but arrogant god Thor is cast out... https://m.media-amazon.com/images/M/MV5BOGE4Nz... 45 ... Male Blue 6'6 640 lb Asgardian Asgard King of Asgard; formerly EMS Technician; Physi... https://cdn.rawgit.com/akabab/superhero-api/0.... 69 100
10 tt3501632 Thor: Ragnarok Chris Hemsworth Thor Thor Odinson 2017 Walt Disney Pictures Imprisoned on the planet Sakaar, Thor must rac... https://m.media-amazon.com/images/M/MV5BMjMyND... 20 ... Male Blue 6'6 640 lb Asgardian Asgard King of Asgard; formerly EMS Technician; Physi... https://cdn.rawgit.com/akabab/superhero-api/0.... 69 100
11 tt0770828 Man of Steel Henry Cavill Superman Clark Kent 2013 Warner Bros. Pictures An alien child is evacuated from his dying wor... https://m.media-amazon.com/images/M/MV5BMTk5OD... 46 ... Male Blue 6'3 225 lb Kryptonian Krypton Reporter for the Daily Planet and novelist https://cdn.rawgit.com/akabab/superhero-api/0.... 94 100
12 tt0348150 Superman Returns Brandon Routh Superman Clark Kent 2006 Warner Bros. Pictures Superman returns to Earth after spending five ... https://m.media-amazon.com/images/M/MV5BNzY2ZD... 39 ... Male Blue 6'3 225 lb Kryptonian Krypton Reporter for the Daily Planet and novelist https://cdn.rawgit.com/akabab/superhero-api/0.... 94 100
13 tt0448115 Shazam! Zachary Levi Captain Marvel Billy Batson 2019 New Line Cinema A newly fostered young boy in search of his mo... https://m.media-amazon.com/images/M/MV5BYTE0Yj... 44 ... Male Blue 6'4 225 lb Human Fawcett City, United States - https://cdn.rawgit.com/akabab/superhero-api/0.... 88 100
14 tt0376994 X-Men: The Last Stand Hugh Jackman Wolverine Logan 2006 20th Century Fox The human government develops a cure for mutat... https://m.media-amazon.com/images/M/MV5BNDBhND... 43 ... Male Blue 5'3 300 lb Mutant Alberta, Canada Adventurer, instructor, former bartender, boun... https://cdn.rawgit.com/akabab/superhero-api/0.... 63 89
15 tt0120903 X-Men Hugh Jackman Wolverine Logan 2000 20th Century Fox In a world where mutants (evolved super-powere... https://m.media-amazon.com/images/M/MV5BZmIyMD... 37 ... Male Blue 5'3 300 lb Mutant Alberta, Canada Adventurer, instructor, former bartender, boun... https://cdn.rawgit.com/akabab/superhero-api/0.... 63 89
16 tt1877832 X-Men: Days of Future Past Hugh Jackman Wolverine Logan 2014 20th Century Fox The X-Men send Wolverine to the past in a desp... https://m.media-amazon.com/images/M/MV5BZGIzNW... 30 ... Male Blue 5'3 300 lb Mutant Alberta, Canada Adventurer, instructor, former bartender, boun... https://cdn.rawgit.com/akabab/superhero-api/0.... 63 89
17 tt3315342 Logan Hugh Jackman Wolverine Logan 2017 20th Century Fox In a future where mutants are nearly extinct, ... https://m.media-amazon.com/images/M/MV5BYzc5MT... 24 ... Male Blue 5'3 300 lb Mutant Alberta, Canada Adventurer, instructor, former bartender, boun... https://cdn.rawgit.com/akabab/superhero-api/0.... 63 89
18 tt0478970 Ant-Man Paul Rudd Ant-Man Hank Pym 2015 Disney/Marvel Armed with a super-suit with the astonishing a... https://m.media-amazon.com/images/M/MV5BMjM2NT... 42 ... Male Blue 6'11 270 lb Human Elmsford, New York Adventurer, Biochemist, former manager of Aven... https://cdn.rawgit.com/akabab/superhero-api/0.... 100 32
19 tt5095030 Ant-Man and the Wasp Paul Rudd Ant-Man Hank Pym 2018 Walt Disney Pictures As Scott Lang balances being both a superhero ... https://m.media-amazon.com/images/M/MV5BYjcyYT... 36 ... Male Blue 6'11 270 lb Human Elmsford, New York Adventurer, Biochemist, former manager of Aven... https://cdn.rawgit.com/akabab/superhero-api/0.... 100 32
20 tt0948470 The Amazing Spider-Man Andrew Garfield Spider-Man Peter Parker 2012 Sony Pictures After Peter Parker is bitten by a genetically ... https://m.media-amazon.com/images/M/MV5BMjMyOT... 41 ... Male Hazel 5'10 165 lb Human New York, New York Freelance photographer, teacher https://cdn.rawgit.com/akabab/superhero-api/0.... 90 74
21 tt0413300 Spider-Man 3 Tobey Maguire Spider-Man Peter Parker 2007 Sony Pictures A strange black entity from another world bond... https://m.media-amazon.com/images/M/MV5BYTk3MD... 34 ... Male Hazel 5'10 165 lb Human New York, New York Freelance photographer, teacher https://cdn.rawgit.com/akabab/superhero-api/0.... 90 74
22 tt4633694 Spider-Man: Into the Spider-Verse Shameik Moore Spider-Man Peter Parker 2018 Sony Pictures Teen Miles Morales becomes the Spider-Man of h... https://m.media-amazon.com/images/M/MV5BMjMwND... 29 ... Male Hazel 5'10 165 lb Human New York, New York Freelance photographer, teacher https://cdn.rawgit.com/akabab/superhero-api/0.... 90 74
23 tt6320628 Spider-Man: Far From Home Tom Holland Spider-Man Peter Parker 2019 Sony Pictures Following the events of Avengers: Endgame (201... https://m.media-amazon.com/images/M/MV5BMGZlNT... 15 ... Male Hazel 5'10 165 lb Human New York, New York Freelance photographer, teacher https://cdn.rawgit.com/akabab/superhero-api/0.... 90 74
24 tt2250912 Spider-Man: Homecoming Tom Holland Spider-Man Peter Parker 2017 Sony Pictures Peter Parker balances his life as an ordinary ... https://m.media-amazon.com/images/M/MV5BNTk4OD... 14 ... Male Hazel 5'10 165 lb Human New York, New York Freelance photographer, teacher https://cdn.rawgit.com/akabab/superhero-api/0.... 90 74
25 tt0316654 Spider-Man 2 Tobey Maguire Spider-Man Peter Parker 2004 Sony Pictures Peter Parker is beset with troubles in his fai... https://m.media-amazon.com/images/M/MV5BMzY2OD... 7 ... Male Hazel 5'10 165 lb Human New York, New York Freelance photographer, teacher https://cdn.rawgit.com/akabab/superhero-api/0.... 90 74
26 tt0145487 Spider-Man Tobey Maguire Spider-Man Peter Parker 2002 Columbia Pictures When bitten by a genetically modified spider, ... https://m.media-amazon.com/images/M/MV5BZDEyN2... 6 ... Male Hazel 5'10 165 lb Human New York, New York Freelance photographer, teacher https://cdn.rawgit.com/akabab/superhero-api/0.... 90 74
27 tt0458339 Captain America: The First Avenger Chris Evans Captain America Steve Rogers 2011 Paramount Pictures Steve Rogers, a rejected military soldier, tra... https://m.media-amazon.com/images/M/MV5BMTYzOT... 40 ... Male blue 6'2 240 lb Human Manhattan, New York City, New York Adventurer, federal official, intelligence ope... https://cdn.rawgit.com/akabab/superhero-api/0.... 69 60
28 tt1843866 Captain America: The Winter Soldier Chris Evans Captain America Steve Rogers 2014 Walt Disney Pictures As Steve Rogers struggles to embrace his role ... https://m.media-amazon.com/images/M/MV5BMzA2ND... 22 ... Male blue 6'2 240 lb Human Manhattan, New York City, New York Adventurer, federal official, intelligence ope... https://cdn.rawgit.com/akabab/superhero-api/0.... 69 60
29 tt3498820 Captain America: Civil War Chris Evans Captain America Steve Rogers 2016 Walt Disney Pictures Political involvement in the Avengers' affairs... https://m.media-amazon.com/images/M/MV5BMjQ0MT... 11 ... Male blue 6'2 240 lb Human Manhattan, New York City, New York Adventurer, federal official, intelligence ope... https://cdn.rawgit.com/akabab/superhero-api/0.... 69 60
30 tt1270798 X-Men: First Class James McAvoy Professor X Charles Francis Xavier 2011 20th Century Fox In the 1960s, superpowered humans Charles Xavi... https://m.media-amazon.com/images/M/MV5BMTg5OT... 38 ... Male Blue 6' 190 lb Mutant New York, New York Mutant leader, mutant rights activist, genetic... https://cdn.rawgit.com/akabab/superhero-api/0.... 100 100
31 tt0290334 X2: X-Men United Patrick Stewart Professor X Charles Francis Xavier 2003 20th Century Fox When anti-mutant Colonel William Stryker kidna... https://m.media-amazon.com/images/M/MV5BNDk0Nj... 27 ... Male Blue 6' 190 lb Mutant New York, New York Mutant leader, mutant rights activist, genetic... https://cdn.rawgit.com/akabab/superhero-api/0.... 100 100
32 tt1477834 Aquaman Jason Momoa Aquaman Orin 2018 Warner Bros. Pictures Arthur Curry (Jason Momoa), the human-born hei... https://m.media-amazon.com/images/M/MV5BOTk5OD... 35 ... Male Blue 6'1 325 lb Atlantean Atlantis Protector of the Seas and Oceans, King of Pose... https://cdn.rawgit.com/akabab/superhero-api/0.... 81 100
33 tt1211837 Doctor Strange Benedict Cumberbatch Doctor Strange Stephen Strange 2016 Walt Disney Pictures While on a journey of physical and spiritual h... https://m.media-amazon.com/images/M/MV5BNjgwNz... 33 ... Male Grey 6'2 180 lb Human Philadelphia, Pennsylvania Sorcerer Supreme, retired neurosurgeon https://cdn.rawgit.com/akabab/superhero-api/0.... 100 100
34 tt0081573 Superman II Gene Hackman Lex Luthor Lex Luthor 1980 Warner Bros. Pictures Superman agrees to sacrifice his powers to sta... https://m.media-amazon.com/images/M/MV5BMWUzND... 28 ... Male Green 6'2' 210 lb Human - Owner of LexCorp https://cdn.rawgit.com/akabab/superhero-api/0.... 100 68
35 tt1228705 Iron Man 2 Robert Downey Jr. Iron Man Tony Stark 2010 Paramount Studios With the world now aware of his identity as Ir... https://m.media-amazon.com/images/M/MV5BMTM0MD... 26 ... Male Blue 6'6 425 lb Human Long Island, New York Inventor, Industrialist; former United States ... https://cdn.rawgit.com/akabab/superhero-api/0.... 100 100
36 tt2395427 Avengers: Age of Ultron Robert Downey Jr. Iron Man Tony Stark 2015 Walt Disney Pictures When Tony Stark and Bruce Banner try to jump-s... https://m.media-amazon.com/images/M/MV5BMTM4OG... 21 ... Male Blue 6'6 425 lb Human Long Island, New York Inventor, Industrialist; former United States ... https://cdn.rawgit.com/akabab/superhero-api/0.... 100 100
37 tt1300854 Iron Man 3 Robert Downey Jr. Iron Man Tony Stark 2013 Walt Disney Pictures When Tony Stark's world is torn apart by a for... https://m.media-amazon.com/images/M/MV5BMjE5Mz... 16 ... Male Blue 6'6 425 lb Human Long Island, New York Inventor, Industrialist; former United States ... https://cdn.rawgit.com/akabab/superhero-api/0.... 100 100
38 tt0371746 Iron Man Robert Downey Jr. Iron Man Tony Stark 2008 Paramount Pictures After being held captive in an Afghan cave, bi... https://m.media-amazon.com/images/M/MV5BMTczNT... 10 ... Male Blue 6'6 425 lb Human Long Island, New York Inventor, Industrialist; former United States ... https://cdn.rawgit.com/akabab/superhero-api/0.... 100 100
39 tt4154756 Avengers: Infinity War Robert Downey Jr. Iron Man Tony Stark 2018 Walt Disney Pictures The Avengers and their allies must be willing ... https://m.media-amazon.com/images/M/MV5BMjMxNj... 9 ... Male Blue 6'6 425 lb Human Long Island, New York Inventor, Industrialist; former United States ... https://cdn.rawgit.com/akabab/superhero-api/0.... 100 100
40 tt0848228 The Avengers Robert Downey Jr. Iron Man Tony Stark 2012 Walt Disney Pictures Earth's mightiest heroes must come together an... https://m.media-amazon.com/images/M/MV5BNDYxNj... 4 ... Male Blue 6'6 425 lb Human Long Island, New York Inventor, Industrialist; former United States ... https://cdn.rawgit.com/akabab/superhero-api/0.... 100 100
41 tt4154796 Avengers: Endgame Robert Downey Jr. Iron Man Tony Stark 2019 Marvel Studios After the devastating events of Avengers: Infi... https://m.media-amazon.com/images/M/MV5BMTc5MD... 3 ... Male Blue 6'6 425 lb Human Long Island, New York Inventor, Industrialist; former United States ... https://cdn.rawgit.com/akabab/superhero-api/0.... 100 100
42 tt5463162 Deadpool 2 Ryan Reynolds Juggernaut Cain Marko 2018 20th Century Fox Foul-mouthed mutant mercenary Wade Wilson (a.k... https://m.media-amazon.com/images/M/MV5BNjk1Nj... 25 ... Male Blue 9'5 1900 lb Human Berkeley, California Adventurer formerly Professional criminal, mer... https://cdn.rawgit.com/akabab/superhero-api/0.... 44 85
43 tt1431045 Deadpool Ryan Reynolds Juggernaut Cain Marko 2016 20th Century Fox A wisecracking mercenary gets experimented on ... https://m.media-amazon.com/images/M/MV5BYzE5Mj... 17 ... Male Blue 9'5 1900 lb Human Berkeley, California Adventurer formerly Professional criminal, mer... https://cdn.rawgit.com/akabab/superhero-api/0.... 44 85
44 tt4154664 Captain Marvel Brie Larson Captain Marvel Carol Danvers 2019 Marvel Studios Carol Danvers becomes one of the universe's mo... https://m.media-amazon.com/images/M/MV5BMTE0YW... 23 ... Female Blue 5'11 165 lb Human-Kree Boston, Massachusetts Former National Aeronautics and Space Administ... https://cdn.rawgit.com/akabab/superhero-api/0.... 84 100
45 tt3896198 Guardians of the Galaxy Vol. 2 Chris Pratt Star-Lord Peter Jason Quill 2017 Walt Disney Pictures The Guardians struggle to keep together as a t... https://m.media-amazon.com/images/M/MV5BNjM0NT... 19 ... Male Blue 6'2 175 lb Human-Spartoi - Adventurer; Royal Prince of Spartax https://cdn.rawgit.com/akabab/superhero-api/0.... 69 25
46 tt2015381 Guardians of the Galaxy Chris Pratt Star-Lord Peter Jason Quill 2014 Walt Disney Pictures A group of intergalactic criminals must pull t... https://m.media-amazon.com/images/M/MV5BMTAwMj... 13 ... Male Blue 6'2 175 lb Human-Spartoi - Adventurer; Royal Prince of Spartax https://cdn.rawgit.com/akabab/superhero-api/0.... 69 25
47 tt0451279 Wonder Woman Gal Gadot Wonder Woman Diana Prince 2017 Warner Bros. Pictures When a pilot crashes and tells of conflict in ... https://m.media-amazon.com/images/M/MV5BNDFmZj... 8 ... Female Blue 6'0 165 lb Amazon Themyscira Adventurer, Emissary to the world of Man, Prot... https://cdn.rawgit.com/akabab/superhero-api/0.... 88 100
48 tt0078346 Superman Marlon Brando Jor-El Jor-El 1978 Warner Bros. Pictures An alien orphan is sent from his dying planet ... https://m.media-amazon.com/images/M/MV5BMzA0YW... 5 ... Male Blue avr avr human Krypton, a scientist https://vignette.wikia.nocookie.net/supermanre... high high
49 tt1825683 Black Panther Chadwick Boseman Black Panther T'Challa 2018 Marvel Studios T'Challa, heir to the hidden but advanced king... https://m.media-amazon.com/images/M/MV5BMTg1MT... 2 ... Male Brown 6'0 200 lb Human Wakanda, Africa King and Chieftain of Wakanda, scientist; form... https://cdn.rawgit.com/akabab/superhero-api/0.... 88 41

50 rows × 24 columns

In [50]:
# Cleaning data for movie_actor_hero_df
movie_actor_hero_df = movie_actor_hero_df.drop(['imdbID','title', 'Role1' , 'Role2', 'Production', 'eyeColor', 'height', 'weight', 'race', 'intelligence', 'power'], axis = 1)
In [51]:
movie_actor_hero_df.head(1)
Out[51]:
Title Actor Year Plot Poster rank boxOffice name fullName gender placeOfBirth work images
0 The Crow Brandon Lee 1994 A man brutally murdered comes back to life as ... https://m.media-amazon.com/images/M/MV5BM2Y4ZG... 50 83.3 Crow Eric Draven Male Earth a rock musician https://upload.wikimedia.org/wikipedia/en/3/39...
In [52]:
# Renaming columns
movie_actor_hero_df = movie_actor_hero_df.rename(columns={"rank": "Movie_Rank", 
                                                        "boxOffice": "Box_Office",
                                                        "name": "Hero_Name",
                                                        "fullName": "Hero_Full_Name",
                                                        "gender": "Hero_Genger",
                                                        "placeOfBirth": "Hero_Place_Of_Birth",
                                                        "work": "Hero_work",
                                                        "images": "Hero_Images"
                                                       })

movie_actor_hero_df
Out[52]:
Title Actor Year Plot Poster Movie_Rank Box_Office Hero_Name Hero_Full_Name Hero_Genger Hero_Place_Of_Birth Hero_work Hero_Images
0 The Crow Brandon Lee 1994 A man brutally murdered comes back to life as ... https://m.media-amazon.com/images/M/MV5BM2Y4ZG... 50 83.3 Crow Eric Draven Male Earth a rock musician https://upload.wikimedia.org/wikipedia/en/3/39...
1 Batman Forever Val Kilmer 1995 Batman must battle former district attorney Ha... https://m.media-amazon.com/images/M/MV5BNDdjYm... 49 295.0 Batman Bruce Wayne Male Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0....
2 Batman Returns Michael Keaton 1992 Batman returns to the big screen when a deform... https://m.media-amazon.com/images/M/MV5BOGZmYz... 32 283.0 Batman Bruce Wayne Male Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0....
3 Batman Begins Christian Bale 2005 After training with his mentor, Batman begins ... https://m.media-amazon.com/images/M/MV5BZmUwNG... 31 256.0 Batman Bruce Wayne Male Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0....
4 Batman Michael Keaton 1989 The Dark Knight of Gotham City begins his war ... https://m.media-amazon.com/images/M/MV5BMTYwNj... 18 493.0 Batman Bruce Wayne Male Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0....
5 The Dark Knight Rises Christian Bale 2012 Eight years after the Joker's reign of anarchy... https://m.media-amazon.com/images/M/MV5BMTk4OD... 12 482.0 Batman Bruce Wayne Male Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0....
6 The Dark Knight Christian Bale 2008 When the menace known as the Joker wreaks havo... https://m.media-amazon.com/images/M/MV5BMTMxNT... 1 612.0 Batman Bruce Wayne Male Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0....
7 Hellboy II: The Golden Army Ron Perlman 2008 The mythical world starts a rebellion against ... https://m.media-amazon.com/images/M/MV5BMjA5Nz... 48 87.0 Hellboy Anung Un Rama Male - - https://cdn.rawgit.com/akabab/superhero-api/0....
8 Thor: The Dark World Chris Hemsworth 2013 When the Dark Elves attempt to plunge the univ... https://m.media-amazon.com/images/M/MV5BMTQyNz... 47 219.0 Thor Thor Odinson Male Asgard King of Asgard; formerly EMS Technician; Physi... https://cdn.rawgit.com/akabab/superhero-api/0....
9 Thor Chris Hemsworth 2011 The powerful but arrogant god Thor is cast out... https://m.media-amazon.com/images/M/MV5BOGE4Nz... 45 199.0 Thor Thor Odinson Male Asgard King of Asgard; formerly EMS Technician; Physi... https://cdn.rawgit.com/akabab/superhero-api/0....
10 Thor: Ragnarok Chris Hemsworth 2017 Imprisoned on the planet Sakaar, Thor must rac... https://m.media-amazon.com/images/M/MV5BMjMyND... 20 315.0 Thor Thor Odinson Male Asgard King of Asgard; formerly EMS Technician; Physi... https://cdn.rawgit.com/akabab/superhero-api/0....
11 Man of Steel Henry Cavill 2013 An alien child is evacuated from his dying wor... https://m.media-amazon.com/images/M/MV5BMTk5OD... 46 309.0 Superman Clark Kent Male Krypton Reporter for the Daily Planet and novelist https://cdn.rawgit.com/akabab/superhero-api/0....
12 Superman Returns Brandon Routh 2006 Superman returns to Earth after spending five ... https://m.media-amazon.com/images/M/MV5BNzY2ZD... 39 286.0 Superman Clark Kent Male Krypton Reporter for the Daily Planet and novelist https://cdn.rawgit.com/akabab/superhero-api/0....
13 Shazam! Zachary Levi 2019 A newly fostered young boy in search of his mo... https://m.media-amazon.com/images/M/MV5BYTE0Yj... 44 140.4 Captain Marvel Billy Batson Male Fawcett City, United States - https://cdn.rawgit.com/akabab/superhero-api/0....
14 X-Men: The Last Stand Hugh Jackman 2006 The human government develops a cure for mutat... https://m.media-amazon.com/images/M/MV5BNDBhND... 43 286.0 Wolverine Logan Male Alberta, Canada Adventurer, instructor, former bartender, boun... https://cdn.rawgit.com/akabab/superhero-api/0....
15 X-Men Hugh Jackman 2000 In a world where mutants (evolved super-powere... https://m.media-amazon.com/images/M/MV5BZmIyMD... 37 223.0 Wolverine Logan Male Alberta, Canada Adventurer, instructor, former bartender, boun... https://cdn.rawgit.com/akabab/superhero-api/0....
16 X-Men: Days of Future Past Hugh Jackman 2014 The X-Men send Wolverine to the past in a desp... https://m.media-amazon.com/images/M/MV5BZGIzNW... 30 244.0 Wolverine Logan Male Alberta, Canada Adventurer, instructor, former bartender, boun... https://cdn.rawgit.com/akabab/superhero-api/0....
17 Logan Hugh Jackman 2017 In a future where mutants are nearly extinct, ... https://m.media-amazon.com/images/M/MV5BYzc5MT... 24 226.0 Wolverine Logan Male Alberta, Canada Adventurer, instructor, former bartender, boun... https://cdn.rawgit.com/akabab/superhero-api/0....
18 Ant-Man Paul Rudd 2015 Armed with a super-suit with the astonishing a... https://m.media-amazon.com/images/M/MV5BMjM2NT... 42 183.0 Ant-Man Hank Pym Male Elmsford, New York Adventurer, Biochemist, former manager of Aven... https://cdn.rawgit.com/akabab/superhero-api/0....
19 Ant-Man and the Wasp Paul Rudd 2018 As Scott Lang balances being both a superhero ... https://m.media-amazon.com/images/M/MV5BYjcyYT... 36 217.0 Ant-Man Hank Pym Male Elmsford, New York Adventurer, Biochemist, former manager of Aven... https://cdn.rawgit.com/akabab/superhero-api/0....
20 The Amazing Spider-Man Andrew Garfield 2012 After Peter Parker is bitten by a genetically ... https://m.media-amazon.com/images/M/MV5BMjMyOT... 41 282.0 Spider-Man Peter Parker Male New York, New York Freelance photographer, teacher https://cdn.rawgit.com/akabab/superhero-api/0....
21 Spider-Man 3 Tobey Maguire 2007 A strange black entity from another world bond... https://m.media-amazon.com/images/M/MV5BYTk3MD... 34 399.0 Spider-Man Peter Parker Male New York, New York Freelance photographer, teacher https://cdn.rawgit.com/akabab/superhero-api/0....
22 Spider-Man: Into the Spider-Verse Shameik Moore 2018 Teen Miles Morales becomes the Spider-Man of h... https://m.media-amazon.com/images/M/MV5BMjMwND... 29 190.0 Spider-Man Peter Parker Male New York, New York Freelance photographer, teacher https://cdn.rawgit.com/akabab/superhero-api/0....
23 Spider-Man: Far From Home Tom Holland 2019 Following the events of Avengers: Endgame (201... https://m.media-amazon.com/images/M/MV5BMGZlNT... 15 373.0 Spider-Man Peter Parker Male New York, New York Freelance photographer, teacher https://cdn.rawgit.com/akabab/superhero-api/0....
24 Spider-Man: Homecoming Tom Holland 2017 Peter Parker balances his life as an ordinary ... https://m.media-amazon.com/images/M/MV5BNTk4OD... 14 333.0 Spider-Man Peter Parker Male New York, New York Freelance photographer, teacher https://cdn.rawgit.com/akabab/superhero-api/0....
25 Spider-Man 2 Tobey Maguire 2004 Peter Parker is beset with troubles in his fai... https://m.media-amazon.com/images/M/MV5BMzY2OD... 7 483.0 Spider-Man Peter Parker Male New York, New York Freelance photographer, teacher https://cdn.rawgit.com/akabab/superhero-api/0....
26 Spider-Man Tobey Maguire 2002 When bitten by a genetically modified spider, ... https://m.media-amazon.com/images/M/MV5BZDEyN2... 6 550.0 Spider-Man Peter Parker Male New York, New York Freelance photographer, teacher https://cdn.rawgit.com/akabab/superhero-api/0....
27 Captain America: The First Avenger Chris Evans 2011 Steve Rogers, a rejected military soldier, tra... https://m.media-amazon.com/images/M/MV5BMTYzOT... 40 194.0 Captain America Steve Rogers Male Manhattan, New York City, New York Adventurer, federal official, intelligence ope... https://cdn.rawgit.com/akabab/superhero-api/0....
28 Captain America: The Winter Soldier Chris Evans 2014 As Steve Rogers struggles to embrace his role ... https://m.media-amazon.com/images/M/MV5BMzA2ND... 22 271.0 Captain America Steve Rogers Male Manhattan, New York City, New York Adventurer, federal official, intelligence ope... https://cdn.rawgit.com/akabab/superhero-api/0....
29 Captain America: Civil War Chris Evans 2016 Political involvement in the Avengers' affairs... https://m.media-amazon.com/images/M/MV5BMjQ0MT... 11 408.0 Captain America Steve Rogers Male Manhattan, New York City, New York Adventurer, federal official, intelligence ope... https://cdn.rawgit.com/akabab/superhero-api/0....
30 X-Men: First Class James McAvoy 2011 In the 1960s, superpowered humans Charles Xavi... https://m.media-amazon.com/images/M/MV5BMTg5OT... 38 161.0 Professor X Charles Francis Xavier Male New York, New York Mutant leader, mutant rights activist, genetic... https://cdn.rawgit.com/akabab/superhero-api/0....
31 X2: X-Men United Patrick Stewart 2003 When anti-mutant Colonel William Stryker kidna... https://m.media-amazon.com/images/M/MV5BNDk0Nj... 27 287.0 Professor X Charles Francis Xavier Male New York, New York Mutant leader, mutant rights activist, genetic... https://cdn.rawgit.com/akabab/superhero-api/0....
32 Aquaman Jason Momoa 2018 Arthur Curry (Jason Momoa), the human-born hei... https://m.media-amazon.com/images/M/MV5BOTk5OD... 35 335.0 Aquaman Orin Male Atlantis Protector of the Seas and Oceans, King of Pose... https://cdn.rawgit.com/akabab/superhero-api/0....
33 Doctor Strange Benedict Cumberbatch 2016 While on a journey of physical and spiritual h... https://m.media-amazon.com/images/M/MV5BNjgwNz... 33 233.0 Doctor Strange Stephen Strange Male Philadelphia, Pennsylvania Sorcerer Supreme, retired neurosurgeon https://cdn.rawgit.com/akabab/superhero-api/0....
34 Superman II Gene Hackman 1980 Superman agrees to sacrifice his powers to sta... https://m.media-amazon.com/images/M/MV5BMWUzND... 28 290.0 Lex Luthor Lex Luthor Male - Owner of LexCorp https://cdn.rawgit.com/akabab/superhero-api/0....
35 Iron Man 2 Robert Downey Jr. 2010 With the world now aware of his identity as Ir... https://m.media-amazon.com/images/M/MV5BMTM0MD... 26 353.0 Iron Man Tony Stark Male Long Island, New York Inventor, Industrialist; former United States ... https://cdn.rawgit.com/akabab/superhero-api/0....
36 Avengers: Age of Ultron Robert Downey Jr. 2015 When Tony Stark and Bruce Banner try to jump-s... https://m.media-amazon.com/images/M/MV5BMTM4OG... 21 467.0 Iron Man Tony Stark Male Long Island, New York Inventor, Industrialist; former United States ... https://cdn.rawgit.com/akabab/superhero-api/0....
37 Iron Man 3 Robert Downey Jr. 2013 When Tony Stark's world is torn apart by a for... https://m.media-amazon.com/images/M/MV5BMjE5Mz... 16 434.0 Iron Man Tony Stark Male Long Island, New York Inventor, Industrialist; former United States ... https://cdn.rawgit.com/akabab/superhero-api/0....
38 Iron Man Robert Downey Jr. 2008 After being held captive in an Afghan cave, bi... https://m.media-amazon.com/images/M/MV5BMTczNT... 10 364.0 Iron Man Tony Stark Male Long Island, New York Inventor, Industrialist; former United States ... https://cdn.rawgit.com/akabab/superhero-api/0....
39 Avengers: Infinity War Robert Downey Jr. 2018 The Avengers and their allies must be willing ... https://m.media-amazon.com/images/M/MV5BMjMxNj... 9 679.0 Iron Man Tony Stark Male Long Island, New York Inventor, Industrialist; former United States ... https://cdn.rawgit.com/akabab/superhero-api/0....
40 The Avengers Robert Downey Jr. 2012 Earth's mightiest heroes must come together an... https://m.media-amazon.com/images/M/MV5BNDYxNj... 4 671.0 Iron Man Tony Stark Male Long Island, New York Inventor, Industrialist; former United States ... https://cdn.rawgit.com/akabab/superhero-api/0....
41 Avengers: Endgame Robert Downey Jr. 2019 After the devastating events of Avengers: Infi... https://m.media-amazon.com/images/M/MV5BMTc5MD... 3 858.0 Iron Man Tony Stark Male Long Island, New York Inventor, Industrialist; former United States ... https://cdn.rawgit.com/akabab/superhero-api/0....
42 Deadpool 2 Ryan Reynolds 2018 Foul-mouthed mutant mercenary Wade Wilson (a.k... https://m.media-amazon.com/images/M/MV5BNjk1Nj... 25 325.0 Juggernaut Cain Marko Male Berkeley, California Adventurer formerly Professional criminal, mer... https://cdn.rawgit.com/akabab/superhero-api/0....
43 Deadpool Ryan Reynolds 2016 A wisecracking mercenary gets experimented on ... https://m.media-amazon.com/images/M/MV5BYzE5Mj... 17 363.0 Juggernaut Cain Marko Male Berkeley, California Adventurer formerly Professional criminal, mer... https://cdn.rawgit.com/akabab/superhero-api/0....
44 Captain Marvel Brie Larson 2019 Carol Danvers becomes one of the universe's mo... https://m.media-amazon.com/images/M/MV5BMTE0YW... 23 427.0 Captain Marvel Carol Danvers Female Boston, Massachusetts Former National Aeronautics and Space Administ... https://cdn.rawgit.com/akabab/superhero-api/0....
45 Guardians of the Galaxy Vol. 2 Chris Pratt 2017 The Guardians struggle to keep together as a t... https://m.media-amazon.com/images/M/MV5BNjM0NT... 19 389.0 Star-Lord Peter Jason Quill Male - Adventurer; Royal Prince of Spartax https://cdn.rawgit.com/akabab/superhero-api/0....
46 Guardians of the Galaxy Chris Pratt 2014 A group of intergalactic criminals must pull t... https://m.media-amazon.com/images/M/MV5BMTAwMj... 13 348.0 Star-Lord Peter Jason Quill Male - Adventurer; Royal Prince of Spartax https://cdn.rawgit.com/akabab/superhero-api/0....
47 Wonder Woman Gal Gadot 2017 When a pilot crashes and tells of conflict in ... https://m.media-amazon.com/images/M/MV5BNDFmZj... 8 412.0 Wonder Woman Diana Prince Female Themyscira Adventurer, Emissary to the world of Man, Prot... https://cdn.rawgit.com/akabab/superhero-api/0....
48 Superman Marlon Brando 1978 An alien orphan is sent from his dying planet ... https://m.media-amazon.com/images/M/MV5BMzA0YW... 5 502.0 Jor-El Jor-El Male Krypton, a scientist https://vignette.wikia.nocookie.net/supermanre...
49 Black Panther Chadwick Boseman 2018 T'Challa, heir to the hidden but advanced king... https://m.media-amazon.com/images/M/MV5BMTg1MT... 2 700.0 Black Panther T'Challa Male Wakanda, Africa King and Chieftain of Wakanda, scientist; form... https://cdn.rawgit.com/akabab/superhero-api/0....
In [53]:
# saving the dataframe to movie_actor_hero.csv file
movie_actor_hero_df.to_csv('movie_actor_hero.csv', index=False) 
movie_actor_hero_df.dtypes
Out[53]:
Title                   object
Actor                   object
Year                    object
Plot                    object
Poster                  object
Movie_Rank              object
Box_Office             float64
Hero_Name               object
Hero_Full_Name          object
Hero_Genger             object
Hero_Place_Of_Birth     object
Hero_work               object
Hero_Images             object
dtype: object
In [1]:
from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
import psycopg2

# Define movie_actor_hero table
class movie_actor_hero(Base):
    __tablename__ = 'movie_actor_hero'
    id = Column(Integer, primary_key=True)
    Title=Column(String)
    Actor=Column(String)
    Year=Column(String)
    Plot=Column(String)
    Poster=Column(String)
    Movie_Rank=Column(String)
    Box_Office =Column(Integer)
    Hero_Name=Column(String)
    Hero_Full_Name=Column(String)
    Hero_Genger=Column(String)
    Hero_Place_Of_Birth=Column(String)
    Hero_work=Column(String)
    Hero_Images=Column(String)
In [2]:
Base.metadata.tables
Out[2]:
immutabledict({'movie_actor_hero': Table('movie_actor_hero', MetaData(bind=None), Column('id', Integer(), table=<movie_actor_hero>, primary_key=True, nullable=False), Column('Title', String(), table=<movie_actor_hero>), Column('Actor', String(), table=<movie_actor_hero>), Column('Year', String(), table=<movie_actor_hero>), Column('Plot', String(), table=<movie_actor_hero>), Column('Poster', String(), table=<movie_actor_hero>), Column('Movie_Rank', String(), table=<movie_actor_hero>), Column('Box_Office', Integer(), table=<movie_actor_hero>), Column('Hero_Name', String(), table=<movie_actor_hero>), Column('Hero_Full_Name', String(), table=<movie_actor_hero>), Column('Hero_Genger', String(), table=<movie_actor_hero>), Column('Hero_Place_Of_Birth', String(), table=<movie_actor_hero>), Column('Hero_work', String(), table=<movie_actor_hero>), Column('Hero_Images', String(), table=<movie_actor_hero>), schema=None)})
In [5]:
# Transform premise DataFrame
csv_file = "movie_actor_hero.csv"
premise_data_df = pd.read_csv(csv_file)
premise_data_df.head()
Out[5]:
Title Actor Year Plot Poster Movie_Rank Box_Office Hero_Name Hero_Full_Name Hero_Genger Hero_Place_Of_Birth Hero_work Hero_Images
0 The Crow Brandon Lee 1994 A man brutally murdered comes back to life as ... https://m.media-amazon.com/images/M/MV5BM2Y4ZG... 50 83.3 Crow Eric Draven Male Earth a rock musician https://upload.wikimedia.org/wikipedia/en/3/39...
1 Batman Forever Val Kilmer 1995 Batman must battle former district attorney Ha... https://m.media-amazon.com/images/M/MV5BNDdjYm... 49 295.0 Batman Bruce Wayne Male Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0....
2 Batman Returns Michael Keaton 1992 Batman returns to the big screen when a deform... https://m.media-amazon.com/images/M/MV5BOGZmYz... 32 283.0 Batman Bruce Wayne Male Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0....
3 Batman Begins Christian Bale 2005 After training with his mentor, Batman begins ... https://m.media-amazon.com/images/M/MV5BZmUwNG... 31 256.0 Batman Bruce Wayne Male Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0....
4 Batman Michael Keaton 1989 The Dark Knight of Gotham City begins his war ... https://m.media-amazon.com/images/M/MV5BMTYwNj... 18 493.0 Batman Bruce Wayne Male Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0....
In [9]:
# Creating a DataBase
engine=psycopg2.connect(f'postgresql://postgres:postgres@localhost:5432')
engine.autocommit=True
cursor=engine.cursor()
sql='''Create database best_50_movies_heroes_db''';
cursor.execute(sql)
In [10]:
# Create database connection
engine=create_engine(f'postgresql://postgres:postgres@localhost:5432/best_50_movies_heroes_db')
In [11]:
# Confirm tables
Base.metadata.create_all(engine)
engine.table_names()
Out[11]:
['movie_actor_hero']
In [12]:
# Load DataFrames into database
premise_data_df.to_sql(name='movie_actor_hero', con=engine, if_exists='append', index=False)
In [13]:
# Confirm data has been added by querying the movie_actor_hero table
pd.read_sql_query('select * from movie_actor_hero', con=engine).head()
Out[13]:
id Title Actor Year Plot Poster Movie_Rank Box_Office Hero_Name Hero_Full_Name Hero_Genger Hero_Place_Of_Birth Hero_work Hero_Images
0 1 The Crow Brandon Lee 1994 A man brutally murdered comes back to life as ... https://m.media-amazon.com/images/M/MV5BM2Y4ZG... 50 83 Crow Eric Draven Male Earth a rock musician https://upload.wikimedia.org/wikipedia/en/3/39...
1 2 Batman Forever Val Kilmer 1995 Batman must battle former district attorney Ha... https://m.media-amazon.com/images/M/MV5BNDdjYm... 49 295 Batman Bruce Wayne Male Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0....
2 3 Batman Returns Michael Keaton 1992 Batman returns to the big screen when a deform... https://m.media-amazon.com/images/M/MV5BOGZmYz... 32 283 Batman Bruce Wayne Male Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0....
3 4 Batman Begins Christian Bale 2005 After training with his mentor, Batman begins ... https://m.media-amazon.com/images/M/MV5BZmUwNG... 31 256 Batman Bruce Wayne Male Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0....
4 5 Batman Michael Keaton 1989 The Dark Knight of Gotham City begins his war ... https://m.media-amazon.com/images/M/MV5BMTYwNj... 18 493 Batman Bruce Wayne Male Crest Hill, Bristol Township; Gotham County Businessman https://cdn.rawgit.com/akabab/superhero-api/0....
In [55]:
# format jupyter notebook file to HTML file
from nbconvert import HTMLExporter
import codecs
import nbformat

notebook_name = 'ETL-Project.ipynb'
output_file_name = 'output.html'

exporter = HTMLExporter()
output_notebook = nbformat.read(notebook_name, as_version=4)

output, resources = exporter.from_notebook_node(output_notebook)
codecs.open(output_file_name, 'w', encoding='utf-8').write(output)
In [ ]: